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?

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?

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?

Changing Graph Column Order
 

FANTASTIC.

Thanks