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

[Guest]

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]

Hi,

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

HTH
Martin

 

[Guest]

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