View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default graphing problem, please help

Check the chart type. If it's a line chart, you need to have as many cells
for each series, because they all use the same X values. If necessary,
include the blank cells leading up to the shorter series.

If it's an XY chart, you may have to redefine the ranges for each series.
Chart menu Source Data Series tab, click on a series, and check the X
and Y values indicated.

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


"big thunder" wrote in message
...
I have three sets of data, two of which are being plotted just fine with
the xy
scatter graph. The one set, however, won't start at my x value of 0. The
y-values are working fine. X values go up in increments of 0, 0.5, 1, 1.5
etc
all the way up to 12 minutes, but with no 11.5 minute data, so rows 1-24.
Between the six and six and a half minute mark, the graph goes hay-wire
and
shifts away from it's zero start point. I check x1, y1 on my graph and it
is
actually using x3 with y1. If this makes any sense to anybody please help.
thanks.