Show average line by series on a line chart
 

I have a line chart to show actual percentages by month for three different
values I am tracking, I would like to show the average for each item as well
on this chart as a line across the chart so that for each month one can see
if the actual percent is above or below the average for the year, is there a
way to do this easily, I have a cell from the data table that shows overall
year average for each value.
--
Judy Rose Cohen

Show average line by series on a line chart
 

Apply this three times:

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

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


"Judy Rose" wrote in message
...
I have a line chart to show actual percentages by month for three different
values I am tracking, I would like to show the average for each item as
well
on this chart as a line across the chart so that for each month one can
see
if the actual percent is above or below the average for the year, is there
a
way to do this easily, I have a cell from the data table that shows
overall
year average for each value.
--
Judy Rose Cohen