LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maximum number of data points for an xy scatter chart? Rich F Charts and Charting in Excel 7 July 11th 07 03:06 PM
Data Points in Chart Mike Excel Discussion (Misc queries) 4 February 23rd 07 01:20 PM
Combination Bar/Line chart---each with different number of data points Mr Jones Charts and Charting in Excel 0 June 17th 06 06:43 PM
Is there a limit to the number of points in a chart source data jantoni Charts and Charting in Excel 1 December 9th 05 03:43 PM
A question regarding coordinates of points within a chart Wazooli Charts and Charting in Excel 3 May 15th 05 05:29 AM


All times are GMT +1. The time now is 05:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"