A
ace
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
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