Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

charts excel

ResolvedVersion 2007

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

Excel tip:

Add a € to your cells

If you need to add a € symbol to your Excel sheet - hold down the key Alt Gr and 4.

Alt Gr is located on the right side of the space bar.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.