ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart Question regarding number of data points (https://www.excelbanter.com/charts-charting-excel/226484-chart-question-regarding-number-data-points.html)

ace

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


All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com