Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultancy - Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel consultancy - Excel

Resolved · Low Priority · Version Standard

Reply Tue 5 Jun 2007, 12:52Delegate Clare said...

Clare has attended:
Excel Intermediate course

Excel

How do I rename legends in charts?

For upcoming training course dates see: Pricing & availability

Reply Tue 5 Jun 2007, 17:04Trainer Amanda said...

RE: Excel

Hi Clare

Thanks for your question.

You can change what shows in a chart legend at step 2 of the chart wizard.

1. If you go onto the Series tab, select the item showing in the legend that you wish to replace with something else, in the box headed 'Series'.

2. Then click in the Name box to the right of this, and select the cell from out of your spreadsheet that contains the correct name for the legend item.

Repeat 1 and 2 above until you have renamed each legend item.

Then click OK.

I hope this helps.
Amanda

Excel articles

· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Update Your VAT Rates In Excel
· Advanced Excel and PivotTable Reports
· Create Contrasting Coloured Rows In Excel
· From novice to expert users - Microsoft Excel fits all

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