Data Points in Chart

G

Guest

What's the maximum number of points allowed on one line in a Chart in Excel
2007? Note: nax is 32000 in Exel 2003.
 
G

Guest

Jon, thanks for your reply. I s there someplace where I can send a
suggestion to change this. This is a significant limitation for me. ///mlh
 
J

Jon Peltier

I think it's already on their minds. With Office 2007, they spent so much
time implementing the extensive new UI, that they ran out of resources to
make all of the changes they intended.

- Jon
 
J

Jon Peltier

Could you work around this by using multiple series which are formatted
identically? You can have a total of 256k points in a chart. That's enough
to cover each pixel on a chart with multiple markers, assuming 1-pixel wide
markers. It's probably also enough to choke Excel 2007's chart redrawing
functionality, from what people have reported on these forums.

- Jon
 

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

Microsoft Excel 1
Interpolating value 1
Chart Question 2
Show Total In a Text Box in a Pie Chart 2
How can I create a line chart with 800,000 data points 3
32000 chart limit warning 1
Selecting data points in a scatter chart 3
Multiple Data Points in an Excel Chart 2

Top