Exceeded data points for a chart

M

Mark W.

MrExcel MVP

Joined

Feb 10, 2002

Messages

11,654

• May 15, 2002

• #2

The limit is 32,000 "data points in a data series for 2-D charts". Just divide your data into 2 or more groups and plot using separate SERIES.

 

Upvote 0

W

wads

New Member

Joined

May 13, 2002

Messages

4

• May 15, 2002

• #3

I am not quite sure how to put it into two data series and have it be one continous plotted line. Can you give me more detail?

 

Upvote 0

M

Mark W.

MrExcel MVP

Joined

Feb 10, 2002

Messages

11,654

• May 15, 2002

• #4

Simply select a set of X,Y values that contains less than 32,000 points and drag them to a blank X-Y (Scatter) chart. Copy/Paste Special... as New Series for succeeding sets until all points are plotted.
Format all data points with same data marker style.
This message was edited by Mark W. on 2002-05-15 12:15

 

Upvote 0

W

wads

New Member

Joined

May 13, 2002

Messages

4

• May 15, 2002

• #5

Thanks Mark W. I tried to do what you said and was successful in getting the data added to the chart. Unfortunately it is not one continous line. The line for the second series at the same point as the first and are plotted separately.

 

Upvote 0

M

Mark W.

MrExcel MVP

Joined

Feb 10, 2002

Messages

11,654

• May 15, 2002

• #6

You didn't say anything about connecting lines -- I thought you were just plotting points! In that case...

Suppose you want to plot...

{"X","Y"
;1,4
;2,2
;3,8
;4,4
;5,7
;6,1
;7,9
;8,3
;9,2}

...as 2 separate SERIES with a continuous connecting line. Just make sure that there's a common endpoint shared by each SERIES. For example, you can plot...

{1,4
;2,2
;3,8
;4,4}

...as the 1st SERIES and then add...

{4,4
;5,7
;6,1
;7,9
;8,3
;9,2}

...as the 2nd. Then as before format all data points with same data marker and line style.
This message was edited by Mark W. on 2002-05-15 17:02

 

Upvote 0

K

kvcpk

New Member

Joined

Jan 25, 2010

Messages

1

• Jan 25, 2010

• #7

Hi Mark,

Thanks for your solution. Can you Please let me know if we can create an adin to perform this task. I will need to perform this task on a regular basis.

Thanks in Advance!!

 

Upvote 0

P

pompy_upb

New Member

Joined

Oct 27, 2011

Messages

1

• Oct 27, 2011

• #8

Hi All,

What can I do if I really need to plot the data in the same series. For example because then I need to obtain a trendline and I do not want to have two, as the two series may look quite different form each other?

Cheers!

 

Upvote 0