need help with pivot charts

J

joe hunter

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

Roger Govier

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.
 
J

Jon Peltier

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
 
R

Roger Govier

Hi Jon

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