ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I get the bars on a chart to display from low to high? (https://www.excelbanter.com/charts-charting-excel/138692-how-do-i-get-bars-chart-display-low-high.html)

201gfc201

How do I get the bars on a chart to display from low to high?
 
I've a simple, horizontal bar chart. The bars appear in the same order as the
data. But I'd like them to appear "in order". Highest to lowest, or vice
versa. IE, a smooth progression of lines getting a little longer with each
one as you look at it. Instead of the random jumble they are in now,
consistent with the random way the data was listed in two columns.

MartinW

How do I get the bars on a chart to display from low to high?
 
Hi,

Select your X data only and go to DataSort select 'Continue with the
current selection' then sort ascending.

HTH
Martin



John Mansfield

How do I get the bars on a chart to display from low to high?
 
Below is a link to a chart that automatically sorts based on a fixed input of
data.

http://www.cellmatrix.net/index.php/auto_sort_chart

--
John Mansfield




"201gfc201" wrote:

I've a simple, horizontal bar chart. The bars appear in the same order as the
data. But I'd like them to appear "in order". Highest to lowest, or vice
versa. IE, a smooth progression of lines getting a little longer with each
one as you look at it. Instead of the random jumble they are in now,
consistent with the random way the data was listed in two columns.



All times are GMT +1. The time now is 09:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com