Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to plot a data of 3 columns as multiple lines on an xy
scatter plot (each line corresponding to values in colum 1). I am currently doing this manually and it is quite painful. I was wondering if there is an easier way to do this. Here's what my data looks like col1 col2 col3 0.1 1 2 0.1 2 3 0.1 3 4 0.2 1 3 0.2 2 8 0.2 3 9 In the above example, I would require two lines (with col2 and col3 on xy scatter). one line for col1 being 0.1, and another for col1 being 0.2 I am currently selecting the data manually and doing this. Is there an easier way? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A scatter plot with a 2 column data source | Charts and Charting in Excel | |||
Avoid plotting refferanced blanks as zeros in scatter plot graphs | Charts and Charting in Excel | |||
Scatter plot with median and interquartile lines | Charts and Charting in Excel | |||
Scatter Plot graph | Charts and Charting in Excel | |||
Plotting Step Graph with XY Scatter | Charts and Charting in Excel |