Single X axis Data vs Multiple Y Axis Data

  • Thread starter Thread starter shrowser
  • Start date Start date
S

shrowser

I have a set of data with multiple scales taken every
hour for 1 month. I wish to plot 4 columns (Column 2 -
Column 5)on the Y axis vs Time (Column 1) on the X axis.

Column 1 Data (10/03/03 11:00 AM)
Column 2 Data (Max 8000, Min 0)
Column 3 Data (Max 750, Min 0)
Column 4 Data (Max 30, Min 1)
Column 5 Data (Max 85, Min 30)

Is this possible in excel.
 
I have a set of data with multiple scales taken every
hour for 1 month. I wish to plot 4 columns (Column 2 -
Column 5)on the Y axis vs Time (Column 1) on the X axis.

Column 1 Data (10/03/03 11:00 AM)
Column 2 Data (Max 8000, Min 0)
Column 3 Data (Max 750, Min 0)
Column 4 Data (Max 30, Min 1)
Column 5 Data (Max 85, Min 30)

Is this possible in excel.
Click to expand...

Sorry to come to the game so late. I missed this earlier.

It appears to me that you simply wish to plot several series on an XY
scatter chart. Select the 5 columns, start the chart wizard, and select
the XY scatter chart type. Excel is smart enough to know that the first
column represents the x-data for all series and will give you 4 series
with columns 2-5 as y-data.
 
Back
Top