training excel vba - Charts

The UK's most regular instructor-led training courses.
Training information: training excel vba · Excel course london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Charts

Davide has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Davide [1 post] (2007 Aug 16 Thu, 15:35) Reply

Can you increase the size of the coloured box of the legend entry without having to increase the font size of the legend entry?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 21 Fri	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 27 Thu	Bloomsbury	4	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	3	book now	£224	£235
2003	2008 Dec 5 Fri	Bayswater	6	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
Full Schedule: See all 99 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Charts

by - trainer Tracy platinum contributer [586 posts] (2007 Aug 17 Fri, 10:05) Reply

Hi

Thanks for the question,

When you are in the chart itself you should be able to click on to the legend and use the black handles on the corner to drag out the size of the legend. This will not affect the font size of the legend entry. If you wanted to change the size of the entry, once selected all the standard formatting toolbars can be used.

Have a go

Tracy

· A Beginners Guide To Formulas In Excel
· Tips for Transitioning to Excel 2007
· Why Should I Learn Visual Basic in Excel?
· Do You Really Need Excel VBA Training?
· Microsoft Excel Training Course

Excel tip:

Get to the end of the used range

What’s the quickest way to get to the bottom right of the used range in your spreadsheet? The two-handed method is Ctrl+End (hold down Ctrl and press End). The one-handed method is End Home (press and release End, and then press and release Home).

The last cell so selected may appear to be empty. However, there is a cell in that row that has an entry or a format and there is a cell in that column that has an entry or format.

View all Excel hints and tips