If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Crazy Combination Chart
Use an area chart, perhaps on secondary axes, for the background, at least the red,
and make the plot area blue. Alternatively, use the Quadrant Background example, but with only one column wide, not two: http://peltiertech.com/Excel/Charts/...ackground.html Using this you need the quadrant stacked bars on primary axis and the % Completion bars on the secondary. Also, go to Chart menu Chart Options Axes tab, and uncheck the secondary Value (Y) axis but check the secondary Category (X) axis. You probably don't need a line at the same level, but if so: http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ SS wrote: 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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple filter query of form | truepantera | Using Forms | 6 | August 4th, 2005 08:26 AM |
How to lock combination chart in pivot chart? | Marcos Novaki | Charts and Charting | 1 | April 13th, 2005 10:05 PM |
How to change Series Order in a Combination Chart? | vrk1 | General Discussion | 0 | March 31st, 2005 11:19 PM |
Chart menu visible property | Sandy V | Charts and Charting | 8 | May 17th, 2004 01:39 PM |
Combination Chart | Juliana | Charts and Charting | 0 | February 18th, 2004 06:26 PM |