Anthony has attended:
Excel VBA Intro Intermediate course
Charts in Excel
Hi
I have never been able to find a solution to this problem, searching the net and asking others has yeilded no results - but I thought it was worth one more try ...
When you create bar/column charts in Excel, is there any way to control the text labels? When you just have a single word they are fine, but the problem arises if you have a short sentence. Excel takes control and determines the proportion of the chart area that is taken up by the text and why you can adjust the plot area it doesnt let you adjust the label area.
Slightly diffiicult to explain in words but I hope that makes sense. I'm not refering to the alignment or size of the text.
Thanks
Anthony
RE: Charts in Excel
Hi Anthony
As you say the plot area of a chart can be altered but not the axis label area. Perhaps send an example of when it becomes a problem? Also please could you let us know the version of Excel.
Thanks
Doug
RE: Charts in Excel
Hi
I'm using Excel 2010. How do I send an example?
Thanks
Anthony
RE: Charts in Excel
Hi Antony
Could you send your example to dougdunn56@gmail.com.
Thanks
Doug