excel courses - charts
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 » excel courses - Charts

excel courses - Charts

resolvedResolved · Low Priority · Version Standard

replyReply Mon 25 Jun 2007, 14:05Delegate Fiona said...

Fiona has attended:
Excel Introduction course
Excel Intermediate course

Charts

How do I name the different legends within the graph that I am making?
Thanks
Fiona

For upcoming training course dates see: Pricing & availability

replyReply Tue 26 Jun 2007, 13:17Trainer Tracy said...

RE: Charts

Hi Fiona,

Thanks for the question

The legends are attached or linked to the spreadsheet. So to change the names on the legend, you will need to rename the titles on your original spreadsheet.

Hope that helps

Tracy

replyReply Tue 26 Jun 2007, 13:25Delegate Fiona said...

RE: Charts

Hi Tracey

Thanks for your reply, however I think I may not of made myself clear so I will try to give some further information. My spreadsheet is made up of donations (totals) of which there are 11 and all of these fall under it's own title. However, when I highlight the titles and the totals to form my graph excel does not transfer the titles. Not sure if this makes my question clearer. I want to be able to see the value of each title and have the title under the axis at the bottom of the graph.

Hope you may be able to guide me further.
Thanks
Fiona

replyReply Fri 29 Jun 2007, 13:59Trainer Tracy said...

RE: Charts

Hi Fiona,

Sorry for the delay I have been out training for a few days and returned today. Would you like to attach the chart/data you are refering to so I can help you

Tracy

replyReply Mon 2 Jul 2007, 08:50Delegate Fiona said...

RE: Charts

Hi Tracey

After some playing I have managed to name them but I think I will ask the question when I attend the next course in a couple of weeks. Thanks for your offer I may take it up in the future!
Regards
Fiona

 

Excel tip:

Jumping Across the Excel Screen

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Alt+PgDn and Alt+PgUp is the equivalent across the spreadsheet.

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