ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Plotting 3 column data as mutiple xy scatter plot lines on same graph (https://www.excelbanter.com/excel-discussion-misc-queries/183269-plotting-3-column-data-mutiple-xy-scatter-plot-lines-same-graph.html)

Mahurshi Akilla

Plotting 3 column data as mutiple xy scatter plot lines on same graph
 
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.


All times are GMT +1. The time now is 07:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com