| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display message upon file open even with macro security set to high | Excel Discussion (Misc queries) | |||
| XY Scatter Charts, High/Low bars, Multiple Series | Charts and Charting in Excel | |||
| High bars | Charts and Charting in Excel | |||
| Chart to display only bars for values that are > 3 & blank cells | Excel Worksheet Functions | |||
| How to display chart with three bars and one line? | Charts and Charting in Excel | |||
Hybrid Mode
