98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Charts / Graphs
Charts / Graphs
Resolved · 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...
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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:3D formulas find and replaceAfter 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. |