charts excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Charts in Excel

Charts in Excel

resolvedResolved · Low Priority · Version 2007

replyReply Thu 1 Sep 2011, 11:40Delegate Anthony said...

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

For upcoming training course dates see: Pricing & availability

replyReply Thu 1 Sep 2011, 15:15Trainer Doug said...

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

replyReply Mon 5 Sep 2011, 09:02Delegate Anthony said...

RE: Charts in Excel

Hi

I'm using Excel 2010. How do I send an example?

Thanks

Anthony

replyReply Mon 5 Sep 2011, 14:18Trainer Doug said...

RE: Charts in Excel

Hi Antony
Could you send your example to dougdunn56@gmail.com.

Thanks
Doug

 

Please browse our web site to find out more about
microsoft+excel+training and other Microsoft training courses.

Excel tip:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.
=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard