average Line created in an existing line graph- based on one cell
 

I am trying to create an average line across a current line graph. I would
like it to be based only one cell so that i dont have to update the x axis
every time more information is input into the spreadsheet.

Is there a way to just have a line that only has the Y axis change based on
one cell, and the X axis is not defined? I would like to have the line
extend to the end of the chart no matter what the x axis looks like.

right now i am usuing =SERIES("Average",,DATA!$M$4:$M$2401,2)
-i have to increase the 2401 number every time more data is added even
though the average is calculated in column M and just repeated over and over.
i have found if i dont increase that number the line stops too short on my
graph and is shorter than the line graph i am trying to compare it with.

Thank you!

average Line created in an existing line graph- based on one cell
 

I am sure one of these will help you:
http://peltiertech.com/Excel/Charts/AddLine.html
http://www.andypope.info/charts/averageline.htm
http://tushar-mehta.com/excel/charts...nes/index.html
Happy New Year
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


"Melanie" wrote in message
...
I am trying to create an average line across a current line graph. I would
like it to be based only one cell so that i dont have to update the x axis
every time more information is input into the spreadsheet.

Is there a way to just have a line that only has the Y axis change based
on
one cell, and the X axis is not defined? I would like to have the line
extend to the end of the chart no matter what the x axis looks like.

right now i am usuing =SERIES("Average",,DATA!$M$4:$M$2401,2)
-i have to increase the 2401 number every time more data is added even
though the average is calculated in column M and just repeated over and
over.
i have found if i dont increase that number the line stops too short on my
graph and is shorter than the line graph i am trying to compare it with.

Thank you!

average Line created in an existing line graph- based on one cell
 

http://peltiertech.com/Excel/Charts/...orzErrBar.html

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


"Melanie" wrote in message
...
I am trying to create an average line across a current line graph. I would
like it to be based only one cell so that i dont have to update the x axis
every time more information is input into the spreadsheet.

Is there a way to just have a line that only has the Y axis change based
on
one cell, and the X axis is not defined? I would like to have the line
extend to the end of the chart no matter what the x axis looks like.

right now i am usuing =SERIES("Average",,DATA!$M$4:$M$2401,2)
-i have to increase the 2401 number every time more data is added even
though the average is calculated in column M and just repeated over and
over.
i have found if i dont increase that number the line stops too short on my
graph and is shorter than the line graph i am trying to compare it with.

Thank you!