98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data order for horizontal bar graphs
Data order for horizontal bar graphs
Resolved · Urgent Priority · Version 2007
Wed 20 May 2009, 00:03Delegate Nick said...
Nick has attended:
Excel Intermediate course
Excel Advanced course
PowerPoint Intermediate Advanced course
Data order for horizontal bar graphs
I have a column of data selected for a horizontal bar graph, the graph has inverted my values, so the value in row 1 appears at the bottom of the graph and the value in row 20 appears at ahe top. How do I reset the graph scaling to reflect the correct sequence? Thanks
Thu 21 May 2009, 12:03Trainer Amanda said...
RE: Data order for horizontal bar graphs
Hello Nick
Thank you for your question.
Try the following:
1. Right-click on the vertical axis, and select Format Axis.
2. Under Axis Options in the Format Axis dialogue box, check the Values in Reverse Order checkbox, click Close.
I hope this helps.
Kind regards
Amanda
Wed 27 May 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:Outlining - ungrouping rows or columnsHighlight want you want to ungroup and press ALT + SHIFT + right cursor arrow |
