Excel

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

Resolved · Low Priority · Version Standard

Excel

Jennifer has attended:
Excel Intermediate course

by - delegate Jennifer [1 post] (2008 Mar 4 Tue, 15:27) Reply

When creating a chart, with a time, value and product dimensions, the wizard creates the third demension as a "series 1,2,3" - how do you rename "series" to reflect third dimension in the legend. Is there no edit function for a graph legend?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	3	book now	£475	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	5	book now	£450	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	7	book now	£345	£399
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: excel

by - trainer Mark gold contributer [180 posts] (2008 Mar 6 Thu, 11:31) Reply

Hi Jennifer

Hope you enjoyed the course on Tuesday

in related to your question it is possible to name the series
what you need to do is go to the chart menu and choose source data then in the second tab for series you can name them there

you can also use cells for the name that are pre-created, by highlighting the cells and using them

This should solve it for you

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn’t and you need further clarification then please press the reply button and ask for further clarification with your specific question. In case you have a related question then please ask the question as a separate posting.

Best Regards

Mark East

· Microsoft Office and the Small Business: Part 1 Excel
· How to Create Better Excel Spreadsheets: Part Three
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets

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

Excel tip:

Return to the active cell after scrolling

When I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen.

Shift+Back Space does something similar. Scroll down from the active cell and Shift+Back Space returns me to it and puts the active cell at the top of the screen; scroll up from the active cell and Shift+Back Space returns me to it and puts the active cell at the bottom of the screen.

Note also, that while Ctrl+Back Space will return me back to a selected range, Shift+Back Space only ever returns me to the active cell, which is normally at the top left-hand corner of any selected range.

View all Excel hints and tips

Institute of IT Training - Accredited Training Provider

Prodigy Platinum Learning Partner

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application

Main information pages

Excel

Related articles

Excel tip:

Return to the active cell after scrolling