Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need a chart that has the following characteristics:
Vertical bars indicating % completion. Trendling line indicating 3 period moving average Horizontal line indicating a 95% target Area above the horizontal target line shaded blue, area below shaded red. I am use the Line-Column combo chart to get the veritcal bars and the moving average. I know the moving average can also be done using a trendline (but this will not show a trend line for the first few data points and yes I know it is not a 3 period average for the first two data points, but try explaining that to the people above me). I can also do the 95% target and the shaded areas using draw tools, however, this makes the chart rather difficult to modify. This chart must ultimately me maintained by an individual with minimum excel experience so I need to make it as easy to maintain as possible. Can anyone offer any ideas on how I can get all of this in one chart and make it simple to maintain? Thanks! SS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combination of stock chart and line chart | Charts and Charting in Excel | |||
Combination chart in Pivot | Charts and Charting in Excel | |||
How to lock combination chart in pivot chart? | Charts and Charting in Excel | |||
How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
How to change Series Order in a Combination Chart? | Excel Discussion (Misc queries) |