Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
graphing problem, please help
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
graphing problem, please help
it's an xy chart. i've checked and re-inserted the data series numerous
times. what's strange is that it will only start the shift over as soon as I include the 6.5 minute and beyond values on the x axis. could it be something in the properties? thanks, zach "Jon Peltier" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
graphing problem, please help
Reply to this message. Select the first series, copy the series formula from
the formula bar, and paste the formula into the reply. Repeat for the other two series. Send the reply. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "big thunder" wrote in message ... it's an xy chart. i've checked and re-inserted the data series numerous times. what's strange is that it will only start the shift over as soon as I include the 6.5 minute and beyond values on the x axis. could it be something in the properties? thanks, zach "Jon Peltier" wrote: 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
graphing problem, please help
="Sample 1"
=Sheet1!$A$1:$A$12 =Sheet1!$C$1:$C$12 ="Sample 2" =Sheet2!$E$1:$E$24 =Sheet2!$G$1:$G$24 Sample 2 is the one I am having the problem with. ="Sample 3" =Sheet3!$A$1:$A$13 =Sheet3!$C$1:$C$13 "Jon Peltier" wrote: Reply to this message. Select the first series, copy the series formula from the formula bar, and paste the formula into the reply. Repeat for the other two series. Send the reply. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "big thunder" wrote in message ... it's an xy chart. i've checked and re-inserted the data series numerous times. what's strange is that it will only start the shift over as soon as I include the 6.5 minute and beyond values on the x axis. could it be something in the properties? thanks, zach |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
graphing problem, please help
So the series formula for series 1 is
=SERIES("Sample 1",Sheet1!$A$1:$A$12,Sheet1!$C$1:$C$12,1) I can see no obvious reason for your problem. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "big thunder" wrote in message ... ="Sample 1" =Sheet1!$A$1:$A$12 =Sheet1!$C$1:$C$12 ="Sample 2" =Sheet2!$E$1:$E$24 =Sheet2!$G$1:$G$24 Sample 2 is the one I am having the problem with. ="Sample 3" =Sheet3!$A$1:$A$13 =Sheet3!$C$1:$C$13 "Jon Peltier" wrote: Reply to this message. Select the first series, copy the series formula from the formula bar, and paste the formula into the reply. Repeat for the other two series. Send the reply. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "big thunder" wrote in message ... it's an xy chart. i've checked and re-inserted the data series numerous times. what's strange is that it will only start the shift over as soon as I include the 6.5 minute and beyond values on the x axis. could it be something in the properties? thanks, zach |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graphing R=1+E | Excel Discussion (Misc queries) | |||
Graphing problem. Please help. | Excel Discussion (Misc queries) | |||
Graphing | Charts and Charting in Excel | |||
simple graphing problem | Excel Discussion (Misc queries) | |||
Thorny problem graphing XAxis dates | Charts and Charting in Excel |