Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph an equation on scatterplot graph
Okay, so here's the situation:
We've got an Excel chart displaying calculated values on the y-axis and the day of the analysis on the x-axis. I'd like to add lines on this graph displaying the mean and then lines for + and - the standard deviation to show how each dot's represented value compares to the overall average. It'll just be as simple as y = 75, where the number (in this case, 75) will change every day as the mean is recalculated due to new points being entered. Is there any way to get the graph to look at the cell that's displaying the value of the mean already? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph an equation on scatterplot graph
Have a look at
http://peltiertech.com/Excel/Charts/AddLine.html -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Jonzor" wrote in message ... Okay, so here's the situation: We've got an Excel chart displaying calculated values on the y-axis and the day of the analysis on the x-axis. I'd like to add lines on this graph displaying the mean and then lines for + and - the standard deviation to show how each dot's represented value compares to the overall average. It'll just be as simple as y = 75, where the number (in this case, 75) will change every day as the mean is recalculated due to new points being entered. Is there any way to get the graph to look at the cell that's displaying the value of the mean already? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revenue ranges in scatterplot graph | Excel Discussion (Misc queries) | |||
How do I graph an equation? | Charts and Charting in Excel | |||
Graph an Equation | Excel Discussion (Misc queries) | |||
Graph an Equation | Excel Discussion (Misc queries) | |||
how do I graph a linear equation? | Charts and Charting in Excel |