Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing Graph Column Order
I have lots and lots of data in a table that I've been sharing and building
with folks. The data is in this order on the spreadsheet: CUSTOMER 2007 2006 2005 20004 So when I plot my Column Chart, I get | | x x | x x x | x x x x |__x_____x_____ x_____ x______ 2007 2006 2005 2004 But I'd RATHER show that as a declining trend: | | x x | x x x | x x x x |__x_____x_____ x_____ x______ 2004 2005 2006 2007 I have a bunch of charts already done. Is there a quick and dirty way to make this change? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing Graph Column Order
Select the X-Axis, right-click it, and on the Scale tab, check the
Categories in reverse Order box. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "RJB" wrote in message ... I have lots and lots of data in a table that I've been sharing and building with folks. The data is in this order on the spreadsheet: CUSTOMER 2007 2006 2005 20004 So when I plot my Column Chart, I get | | x x | x x x | x x x x |__x_____x_____ x_____ x______ 2007 2006 2005 2004 But I'd RATHER show that as a declining trend: | | x x | x x x | x x x x |__x_____x_____ x_____ x______ 2004 2005 2006 2007 I have a bunch of charts already done. Is there a quick and dirty way to make this change? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing Graph Column Order
Oh, I forgot as well that you might want to check the Value (Y) Axis crosses
at maximum category, to get the axis labels back on the left. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "RJB" wrote in message ... I have lots and lots of data in a table that I've been sharing and building with folks. The data is in this order on the spreadsheet: CUSTOMER 2007 2006 2005 20004 So when I plot my Column Chart, I get | | x x | x x x | x x x x |__x_____x_____ x_____ x______ 2007 2006 2005 2004 But I'd RATHER show that as a declining trend: | | x x | x x x | x x x x |__x_____x_____ x_____ x______ 2004 2005 2006 2007 I have a bunch of charts already done. Is there a quick and dirty way to make this change? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing Graph Column Order
FANTASTIC.
Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
Changing column order in pivot table | Excel Discussion (Misc queries) | |||
Changing the order of names... | New Users to Excel | |||
changing column's order | Charts and Charting in Excel | |||
changing name order | New Users to Excel |