![]() |
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. |
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 |
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