Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding a line to show average for a data series on a chart | Charts and Charting in Excel | |||
average Line created in an existing line graph- based on one cell | Charts and Charting in Excel | |||
Show average value as a horizontal line in a column chart | Charts and Charting in Excel | |||
Cutting a line in a line chart when data series stops | Charts and Charting in Excel | |||
show the value of the last point of every series, in Excel line ch | Charts and Charting in Excel |