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????

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????

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????

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????