scatter plots with multiple series
I am trying to plot in excel a scatter plot with mulitple xy settings..All
the x setting are time. I am wondering if there is a way with in excel to select the columns and then plot them accordingly Thanks -- Kat |
scatter plots with multiple series
Hi,
If you place your x values in the first column, each set of y values in subsequent columns. On the 2nd step of the chart wizard make sure series data is plotted in Columns. This should produce multiple series with each sharing the 1st column as its x values. Cheers Andy Kat wrote: I am trying to plot in excel a scatter plot with mulitple xy settings..All the x setting are time. I am wondering if there is a way with in excel to select the columns and then plot them accordingly Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
scatter plots with multiple series
The x columns are time, and each time series may not be the same. so this
means I would have to do some prefiltering? -- Kat "Andy Pope" wrote: Hi, If you place your x values in the first column, each set of y values in subsequent columns. On the 2nd step of the chart wizard make sure series data is plotted in Columns. This should produce multiple series with each sharing the 1st column as its x values. Cheers Andy Kat wrote: I am trying to plot in excel a scatter plot with mulitple xy settings..All the x setting are time. I am wondering if there is a way with in excel to select the columns and then plot them accordingly Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
scatter plots with multiple series
Sorry I mis-read "x setting are time." as "x setting are SAME."
I'm not sure I understand the problem. Are you having problems getting multiple series in to the chart? Or is the x axis scale not working in some way? And by time series do you mean hh:mm time or actual dates? Cheers Andy Kat wrote: The x columns are time, and each time series may not be the same. so this means I would have to do some prefiltering? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 06:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com