![]() |
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