need help with pivot charts
 

When working with a pivot chart at work i can access(view) all of the data
in columns
out to column IV. How can I view columns past this point????

need help with pivot charts
 

Hi Joe

XL2003 and lower only have 256 columns, the last being IV.
XL2007 has 16000 columns, but if you have loaded a file created in
XL2003, it will have loaded in compatibility mode, and will only go to
column 256.
Save the file as an XL2007 file (.xlsx), close it and re-open and you
should be able to access columns beyond IV.

--
Regards

Roger Govier


"joe hunter" <joe wrote in message
...
When working with a pivot chart at work i can access(view) all of the
data
in columns
out to column IV. How can I view columns past this point????

need help with pivot charts
 

If you're using Excel 2007, you can have data in columns beyond IV, but a
chart still has a limit of 256 series, and column IV is the 256th.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"joe hunter" <joe wrote in message
...
When working with a pivot chart at work i can access(view) all of the
data
in columns
out to column IV. How can I view columns past this point????

need help with pivot charts
 

Hi Jon

I was unaware of that limitation, thank you for bringing it to my
attention.

--
Regards

Roger Govier


"Jon Peltier" wrote in message
...
If you're using Excel 2007, you can have data in columns beyond IV,
but a chart still has a limit of 256 series, and column IV is the
256th.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"joe hunter" <joe wrote in message
...
When working with a pivot chart at work i can access(view) all of
the data
in columns
out to column IV. How can I view columns past this point????