In the microsoft.public.excel.programming newsgroup, ptheese asked for the following:

I need to chart three groups of two bars on a axis.
-Each group is a year, 2007, 2006, 2005 etc so we can compare data from previous years
-in each group of two there is a profit vertical bar and a combined ratio percentage bar, these bars are not related to each other (one going up has no impact on the other)
-For each of these bars, there needs to be a target indicator, a small horizontal line crossing over the bar (or above it if the target was not hit). This line does not go across the entire chart, there is a separate one for each individual bar.
-For the profit bar, if it crosses above the target bar, it should be green. otherwise red.
-For the ratio/percentage bar, if it crosses above the target bar, it should be red, otherwise green

I’ve come up with the following chart:

For the protocol, see Conditional Stacked Clustered Column Chart with Targets

Possibly Related Posts:

• US Employment Slump Chart – How To
• Chart Busters – Compare Employee Sales
• Adding an Arbitrary Target
• Column Chart to Replace Multiple Pie Charts
• Pie Charts Must Die
• Tornado Charts and Dot Plots
• Candlestick Alternative: Individually Colored Up-Down Bars
• Re: Abortion Ratios 1980-2003
• Clustered-Stacked Column Charts
• Finding Help for Microsoft Excel