Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data order for horizontal bar graphs

Data order for horizontal bar graphs

ResolvedVersion 2007

Wed 20 May 2009, 00:03 Delegate 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:03 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips

Data order for horizontal bar graphs

Data order for horizontal bar graphs

RE: Data order for horizontal bar graphs

Excel articles

Excel tip:

Do a fast scroll