View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
ace ace is offline
external usenet poster
 
Posts: 19
Default Chart Question regarding number of data points

Guys,

this is a question I have. i am building a scatter chart for the following
data set;

20
21
21.5
22
0
0
20

21.5
21.75

The situations is thus; The first seven data points get charted on a scatter
chart using an automatic scale discounting the zeros.
The points 21.5 and 21.75, i.e the last two data points get charted on the
same xy-plane, same axis as the first seven points but on a different chart
with a trend line.

The thing is, there are two 20's in the first seven data points, so it will
get plotted just the once, i mean when i look at the 20 on the graph, i can't
know that there are 2 20's. so in a way, it makes the graph mildly misleading.
Is there any way i can show on the chart or outside it that this is the
number of repetitive data points in the data set?? can this be done
automatically??I mean it looks at a data set just computes the number of
repetitions??

Thanks,
Ace