Excel - add target line to stacked bar chart

Posted by Chris W on Super User See other posts from Super User or by Chris W
Published on 2010-05-20T09:48:11Z Indexed on 2010/05/20 9:50 UTC
Read the original article Hit count: 274

Filed under:
|

I've got a stacked bar chart. I'm displaying a set of floating bars to represent hi/low ranges for some metrics, by using a transparent fill on the bottom section of the bar I achieve the desired look.

What I now need to do is add a horizontal line across the chart to indicate how a particular users score relates to all of these hi/low ranges therefore the placement of this line needs to be dynamic based on a value in a cell.

Is there anyway to do this as I can't find an easy option. If this was a simple bar chart I could add the target scores as new series and use the line chart type but I don't seem able to overlay a second series on the stacked bar chart.

I'm using 2003 at the moment but run this in 2007 if that helps.

© Super User or respective owner

Related posts about excel

Related posts about charts