Re: Creating Average Line on chart

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

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


"flourboy" <flourboy.2biodv_1153857312.2647@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:flourboy.2biodv_1153857312.2647@xxxxxxxxxxxxxxxxxxxxxxxx

I am making creating a bar graph that will graph 7 plants numbers based
on a period. I have excel to where i enter the period # in cell a1 and
then below it, it will pull the information for the period for each
plant. I'm trying to place a line in the graph that will show the
average performance of all of the plants for that period based on a
cell that calculates up the average. Is there any way to set this up?
I have tryed a few things with it but it always brings the average as
another bar or just a dot, not a line like i need


--
flourboy
------------------------------------------------------------------------
flourboy's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=26219
View this thread: http://www.excelforum.com/showthread.php?threadid=564878



.

Relevant Pages

  • Creating Average Line on chart
    ... I am making creating a bar graph that will graph 7 plants numbers based ... cell that calculates up the average. ...
    (microsoft.public.excel.charting)
  • Re: Automatic swap of x - and y - axis
    ... "Jon Peltier" wrote: ... of the chart, and a description of the problem, someone may be able to ... Jon Peltier, Microsoft Excel MVP ... by the time the graph is ...
    (microsoft.public.excel.charting)
  • Re: Automatic swap of x - and y - axis
    ... of the chart, and a description of the problem, someone may be able to help. ... Jon Peltier, Microsoft Excel MVP ... by the time the graph is ... Are the values that were plotted on the horizontal axis now ...
    (microsoft.public.excel.charting)
  • Re: Automatic swap of x - and y - axis
    ... that would keep the chart in its intended configuration. ... Jon Peltier, Microsoft Excel MVP ... The graph changes not when data are entered, ... Are the values that were plotted on the horizontal axis now plotted ...
    (microsoft.public.excel.charting)
  • Re: Automatic swap of x - and y - axis
    ... that would keep the chart in its intended configuration. ... Jon Peltier, Microsoft Excel MVP ... The graph changes not when data are entered, ... Are the values that were plotted on the horizontal axis now plotted ...
    (microsoft.public.excel.charting)