#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default Data Points in Chart

What's the maximum number of points allowed on one line in a Chart in Excel
2007? Note: nax is 32000 in Exel 2003.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default Data Points in Chart

The chart-related limits have not changed in Excel 2007.

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


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



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default Data Points in Chart

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
--
Michael L. Hotaling


"Jon Peltier" wrote:

The chart-related limits have not changed in Excel 2007.

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


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




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default Data Points in Chart

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Mike" wrote in message
...
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
--
Michael L. Hotaling


"Jon Peltier" wrote:

The chart-related limits have not changed in Excel 2007.

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


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






  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default Data Points in Chart

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Mike" wrote in message
...
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
--
Michael L. Hotaling


"Jon Peltier" wrote:

The chart-related limits have not changed in Excel 2007.

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


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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
labeling data points on a scatter chart Mr Tee Charts and Charting in Excel 1 March 31st 06 01:15 PM
Embedding pictures on data points of a chart [email protected] Charts and Charting in Excel 1 February 16th 06 06:30 PM
How do I select multiple data points on my chart? Matthew S Charts and Charting in Excel 1 September 13th 05 06:38 PM
Data Points in Scatter Chart CWILSON Charts and Charting in Excel 2 January 25th 05 04:41 PM
How many data points can you have in an Excel for a Scatter Chart. gregran Charts and Charting in Excel 3 December 10th 04 07:31 PM


All times are GMT +1. The time now is 03:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"