Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maximum number of data points for an xy scatter chart? | Charts and Charting in Excel | |||
Data Points in Chart | Excel Discussion (Misc queries) | |||
Combination Bar/Line chart---each with different number of data points | Charts and Charting in Excel | |||
Is there a limit to the number of points in a chart source data | Charts and Charting in Excel | |||
A question regarding coordinates of points within a chart | Charts and Charting in Excel |