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

excel

ResolvedVersion Standard

Jennifer has attended:
Excel Intermediate course

Excel

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?

RE: excel

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

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

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.13 secs.