Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
pp pp is offline
external usenet poster
 
Posts: 1
Default series order - sorted?

Have I dreamed it, or can you 'sort' a chart series so that, for
example, the category with the highest value appears first on the axis,
the lowest last? It wouldn't be the first excel dream I've had...

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 82
Default series order - sorted?

If I have understand you correctly, you want you graph to appear in an
increasing or decreasing manner.
Before drawing your chart, sort your "Y" values. Then the graph will be
drawn in the sorted manner.
Is this what are you looking for?

"pp" wrote in message
oups.com...
Have I dreamed it, or can you 'sort' a chart series so that, for
example, the category with the highest value appears first on the axis,
the lowest last? It wouldn't be the first excel dream I've had...


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reverse plot order in Excel charts jhawkins49 Charts and Charting in Excel 0 September 18th 06 06:11 PM
PivotCharts and series order Mark Wickett Charts and Charting in Excel 1 August 29th 06 05:19 AM
Chart series Arne Hegefors Charts and Charting in Excel 0 July 18th 06 01:59 PM
How to change Series order in a Combination Chart? vrk1 Charts and Charting in Excel 3 April 1st 05 07:21 AM
series order Bryan Charts and Charting in Excel 3 January 27th 05 12:32 AM


All times are GMT +1. The time now is 03:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"