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
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
For upcoming training course dates see: Pricing & availability
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.
|
