charts graphs

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Charts / Graphs

Charts / Graphs

resolvedResolved · Medium Priority · Version 2003

Steven has attended:
Excel Intermediate course
Excel Advanced course

Charts / Graphs

When doing the charts the legend was upside down when put on the left or right, eg e down to A... can this be reversed so it goes in order A down to E...

RE: Charts / Graphs

Hello Steven

Thank you for your question.

The order that the data displays in is often determined by how the data has been entered into the spreadsheet.

You can't reverse the order that items appear in in the legend, you can reverse the order that items appear in on the horizontal axis.

I've attached an example so you can see how the way the data is entered into the spreadsheet changes how the chart displays.

I hope this helps.
Amanda

Attached files...

charts.xls

RE: Charts / Graphs

Hi Amanda,

At first glance i also did this.. However in your example the legend would not match the data...

Because you have changed legend around but the data has stayed the same..

However i have tried to move all of it around and yes the legend is correct but then the graph looks wrong!!

Please help

Cheers

Steve

RE: Charts / Graphs

Hi Steven

I didn't move the data in the example as I was primarily trying to show what happens to the legend display depending on where the labels are positioned in your spreadsheet.

I'm unsure what you mean about the graph looking wrong once you have moved the data around, can you please explain further or alternatively you can email the graph to me if you like, to amanda@stl-training.co.uk

Kind regards
Amanda

RE: Charts / Graphs

Hello,

This question has now been left unattended for a while.

As we are waiting for your response for further information to help resolve your issue, we will be automatically marking this question as resolved in the next 5 days unless you post a follow-up within that time.

Did you send the e-mail to Amanda?

Thank you.

Rich

Thu 26 Mar 2009: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

3D formulas find and replace

After you know all the components of a 3D reference, you can change them to suit by using a localised Find and replace crt+f, if need be.

View all Excel hints and tips


Server loaded in 0.1 secs.