Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 55
Default Max number of plots/curves

I keep medical data on rather complicated Excel line graph. I currently
have 40 items either plotted (curves) or noted as just data points. X axis
is dates (about 4 years). Although I have never had any trouble adding
info, other than it is getting a bit crowded, is there a limit to how may
items Excel can chart?
Thx
Dave
WIndXP SP2 Office(Excel)2003


  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Max number of plots/curves

In a 2D chart, you can have up to 255 series, a series can have a maximum of
32000 points, and the whole chart can have a maximum of 255000 points. You
have a ways to go.

Of course, depending on your version of Excel, performance may suffer before
you get close to these limits.

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


"Dave" wrote in message
...
I keep medical data on rather complicated Excel line graph. I currently
have 40 items either plotted (curves) or noted as just data points. X axis
is dates (about 4 years). Although I have never had any trouble adding
info, other than it is getting a bit crowded, is there a limit to how may
items Excel can chart?
Thx
Dave
WIndXP SP2 Office(Excel)2003



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 55
Default Max number of plots/curves

Thank you Jon, for the good news -

Looks like I'm going to live until the year 3026. That's probably long
enough !

The understatement of the week - I "have a ways to go." I guess so!

Appreciate the info.

Dave


"Jon Peltier" wrote in message
...
In a 2D chart, you can have up to 255 series, a series can have a maximum
of 32000 points, and the whole chart can have a maximum of 255000 points.
You have a ways to go.

Of course, depending on your version of Excel, performance may suffer
before you get close to these limits.

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


"Dave" wrote in message
...
I keep medical data on rather complicated Excel line graph. I currently
have 40 items either plotted (curves) or noted as just data points. X
axis is dates (about 4 years). Although I have never had any trouble
adding info, other than it is getting a bit crowded, is there a limit to
how may items Excel can chart?
Thx
Dave
WIndXP SP2 Office(Excel)2003





  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 99
Default Max number of plots/curves

Hi,

If, as you say, your chart is getting a bit complicated and crowded, perhaps
you should consider a different sort of chart, perhaps a conditional one
where you select which series you want to show?
After all, a good chart should show your data clearly.

Dave

"Dave" wrote:

Thank you Jon, for the good news -

Looks like I'm going to live until the year 3026. That's probably long
enough !

The understatement of the week - I "have a ways to go." I guess so!

Appreciate the info.

Dave


"Jon Peltier" wrote in message
...
In a 2D chart, you can have up to 255 series, a series can have a maximum
of 32000 points, and the whole chart can have a maximum of 255000 points.
You have a ways to go.

Of course, depending on your version of Excel, performance may suffer
before you get close to these limits.

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


"Dave" wrote in message
...
I keep medical data on rather complicated Excel line graph. I currently
have 40 items either plotted (curves) or noted as just data points. X
axis is dates (about 4 years). Although I have never had any trouble
adding info, other than it is getting a bit crowded, is there a limit to
how may items Excel can chart?
Thx
Dave
WIndXP SP2 Office(Excel)2003






  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 55
Default Max number of plots/curves

Thank you Dave Curtis -
Good point. I do have a couple of partial data charts. I have always kept
my basic data on one worksheet, then use it as a data source for the others.
Unfortunately, I started a plot of ALL data on the original worksheet, just
never realizing how out-of-hand it was going to get. Actually, the basic
data sheet is where the crowding/confusion occurs. I have to use the Hide
feature liberally to add new data.

Guess my question was academic - but the answers have been enlightening

Thank you again

Dave

"Dave Curtis" wrote in message
...
Hi,

If, as you say, your chart is getting a bit complicated and crowded,
perhaps
you should consider a different sort of chart, perhaps a conditional one
where you select which series you want to show?
After all, a good chart should show your data clearly.

Dave

"Dave" wrote:

Thank you Jon, for the good news -

Looks like I'm going to live until the year 3026. That's probably long
enough !

The understatement of the week - I "have a ways to go." I guess so!

Appreciate the info.

Dave


"Jon Peltier" wrote in message
...
In a 2D chart, you can have up to 255 series, a series can have a
maximum
of 32000 points, and the whole chart can have a maximum of 255000
points.
You have a ways to go.

Of course, depending on your version of Excel, performance may suffer
before you get close to these limits.

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


"Dave" wrote in message
...
I keep medical data on rather complicated Excel line graph. I
currently
have 40 items either plotted (curves) or noted as just data points. X
axis is dates (about 4 years). Although I have never had any trouble
adding info, other than it is getting a bit crowded, is there a limit
to
how may items Excel can chart?
Thx
Dave
WIndXP SP2 Office(Excel)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
curves PAL Excel Worksheet Functions 2 June 25th 08 08:15 AM
How can you create Box Plots (Box-and-Whisker Plots) in Excel? Amy Bass Charts and Charting in Excel 3 December 28th 06 01:18 AM
Graph: number of curves AbAcGa Charts and Charting in Excel 5 January 16th 06 04:43 PM
Excel gives me line plots - I want scatter plots Pangloss Charts and Charting in Excel 1 October 14th 05 02:15 PM
combine 2 curves Ruud Excel Worksheet Functions 1 December 7th 04 03:47 PM


All times are GMT +1. The time now is 01:05 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"