If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Label XY scatter plot points by frequency of occurence (no pivot t | Chris Gregory | Charts and Charting | 3 | September 21st, 2005 01:05 AM |
Plot Wizard -- "Not enough system resources to display completely. | Andrew | Charts and Charting | 1 | April 26th, 2005 12:27 AM |
how do i plot a rose diagram to show frequency of wind direction | kathryn | Charts and Charting | 1 | March 15th, 2005 09:42 PM |
Scatter plot changes to line plot with data gaps | Jim | Charts and Charting | 14 | October 8th, 2003 05:10 PM |
Frequency Plot - Medical Test | G | Charts and Charting | 1 | September 16th, 2003 06:00 PM |