need help with pivot charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Hi Jon

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Chart Trendline? 0
Pivot Table Chart? 4
Office Excel 2007 Pivot Data Charting 2
Duplicating Pivot Chart / Changing Pivot Chart data range 4
How to display 2 pieces of data on one bar of a Pivot Chart? 1
Pivot Table Ranges 8
how to show the total in a pivot chart 1
Showing Pivot Table total on Associated Pivot Chart 2

Back
Top