Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
adding a line to show average for a data series on a chart
I would like to add lines to a chart that would be dashed and the color for
the month they would reference to show the average for that month, I have multiple months each month with their own data line that shows percentage for that month by provider, I want to show the average across all providers on the chart, each month would have a dashed line to show it's average so people could see for that month where they fell and to see if the overall average for the percentage of compliance is trending in the right direction month to month.... -- Judy Rose Cohen |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
adding a line to show average for a data series on a chart
Try this method:
http://peltiertech.com/Excel/Charts/...orzSeries.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Judy Rose" wrote in message ... I would like to add lines to a chart that would be dashed and the color for the month they would reference to show the average for that month, I have multiple months each month with their own data line that shows percentage for that month by provider, I want to show the average across all providers on the chart, each month would have a dashed line to show it's average so people could see for that month where they fell and to see if the overall average for the percentage of compliance is trending in the right direction month to month.... -- Judy Rose Cohen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
Adding an Average line (from data sheet) to a chart automatically. | Charts and Charting in Excel | |||
Adding an average line to a bar chart | Excel Discussion (Misc queries) | |||
Adding series, this time with a 2 axes line chart | Charts and Charting in Excel |