View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Scatter Chart w/ Lines limit?

In general the limits are generous: 32,000 points per series, a total of
256,000 points per chart.

Your limit may be due to adding one point at a time using the Ctrl key to
select individual cells. This produces a large series formula, because each
cell has its address (including worksheet name) added to the formula.

The solution is to place your data in contiguous ranges, so you only need to
select a rectangle that includes all of the data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Maurolava" wrote in message
...
I have a scatter chart with 6 different series, one for each day of the
week
( minus sunday) each one list the amount of customers help in my shop on
each
individual day. However after the 11 day, it seems I can not add anymore
dates.

Why can I add more data?

Thank you in advance,

Maurolava