Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
plot frequency
I wasn't able to locate how to solve the following problem, so I thought I'd
post it he I have a 2 long columns of data points (XY scatter format). I want to plot only every 3rd XY pair. Aside from manually selecting every third data point with ctrl+left mouse click, is there an easier way? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
plot frequency
Let's say your data is in A1:A100 with row 1 containing labels.
A has the x-values, B the y-values In C2 enter =IF(MOD(ROW()-1,3)=0,B2,NA()) Copy this down to C100 Select A1:A100, hold CTRL, select C1:C100 (Control key used to select non-contiguous data) Make chart in normal way; Excel will ignore the NA values If first x-value is in A1 use =IF(MOD(ROW(),3)=0,B1,NA()) If first x-value is in A2 use =IF(MOD(ROW()-1,3)=0,B2,NA()) If first x-values is in A3 use =IF(MOD(ROW()-2,3)=0,B3,NA()) If first x-value in A4 use =IF(MOD(ROW(),3)=0,B4,NA()) get the picture? best wishes hope you recover from your XL-distemper! -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "notquitefedupwithxl" wrote in message ... I wasn't able to locate how to solve the following problem, so I thought I'd post it he I have a 2 long columns of data points (XY scatter format). I want to plot only every 3rd XY pair. Aside from manually selecting every third data point with ctrl+left mouse click, is there an easier way? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
plot frequency
To supplement Bernard's suggestion see
Select Markers http://www.tushar-mehta.com/excel/ne...ers/index.html -- Regards, Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach "notquitefedupwithxl" wrote: I wasn't able to locate how to solve the following problem, so I thought I'd post it he I have a 2 long columns of data points (XY scatter format). I want to plot only every 3rd XY pair. Aside from manually selecting every third data point with ctrl+left mouse click, is there an easier way? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
histograms - frequency and relative frequency? | Excel Discussion (Misc queries) | |||
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 | |||
how do i plot a rose diagram to show frequency of wind direction | Charts and Charting in Excel | |||
Frequency for Histograms in Excel | Charts and Charting in Excel |