Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Plot every 10th pt
Hi,
I have a chart with 1000 data points, and these are listed by date. So when I chart the data, there are so many pts that it makes the line look all smudged. Is there any way to only display the 10th or 100th pts. Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Plot every 10th pt
Lets say the x-values are in A1:A100, the y-values in B1:B100
In C1 enter =IF(MOD(ROW(),10)=0,B1,NA()) and copy down the column Now chart A1:A100 with C1:C100 (select A1:A100; hold CTRL and select the C data; now click Chart Wizard) The NA() will display as #N/A and will not get plotted nor will Excel treat it as 0. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Jeff" wrote in message ... Hi, I have a chart with 1000 data points, and these are listed by date. So when I chart the data, there are so many pts that it makes the line look all smudged. Is there any way to only display the 10th or 100th pts. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to increase chart area without affecting plot area? | Charts and Charting in Excel | |||
Continuous series plot | Charts and Charting in Excel | |||
Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel | |||
Plot Wizard -- "Not enough system resources to display completely. | Charts and Charting in Excel | |||
Contour plot | Charts and Charting in Excel |