charting problems

  • Thread starter Thread starter rescugrl
  • Start date Start date
R

rescugrl

I'm using a scatter plot to chart this data (instead of a line graph
which I recently learned about) but it's still not plotting my dat
correctly. I want to do a wind speed (x-axis) vs time (y-axis) plot.
have two sets of values for wind speeds, "predicted" and "observed
(ranging from 0-70 mph) and the time value ranges from 0-23 hours.
think the problem might be in how I'm entering the data in the shee
(of course I'm matching the predicted and observed wind speeds with th
corresponding times) but I don't know which data to enter into whic
column, I've tried it different ways and the plot that results is onl
one line and I can't figure out how excel has messed with the data.
Please help
 
Time on the Y axis? Elapsed time, or running time of day? No matter.

You have two sets of X data, predicted and observed. Put them in a
worksheet in this left to right order: X1, X2, Y

Select the X1 data, hold Shift and select the Y data. Start the chart
wizard, select an XY Scatter chart in step 1. In step 2, click on the
Series tab. There should be one series in the list. Select is, and make
sure the X1 range is in the X values selection box, and the Y range is
in the Y values selection box. If the series name is from a cell, click
in the Name selection box, then select the cell with the mouse. Now
click Add and select the second series in the list. Click in the X
selection box and select the X2 range with the mouse. Click in the Y
selection box and select the Y range with the mouse. If the series name
is from a cell, click in the Name selection box, then select the cell
with the mouse. OK your way through the wizard, and your chart should
have the data plotted the way you want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top