View Single Post
  #1   Report Post  
SS
 
Posts: n/a
Default Crazy Combination Chart

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