Chart Question

[rjacmuto32]

I have a stacked column chart.
Primary Axis I have Target #. The column is shaded white with a black border
Secondary Axis I have 3 numbers that are stacked to show performace vs the target. They are shaded red, yellow, blue.
The gap for the Target is wider so I can see the border.

My question is of that target I want to remove the border and just show the top line.

I tried to make that series a line, with the color to none and marker style to a flat line and the marker width to be as wide as my other bars but it didn't work. Is something wrong?

 

[Jon Peltier]

You might be having problems because you're using primary and secondary axes. You can plot your target line and stacked performance columns all on the primary axis. The lines and columns will be using the same scale, which I suspect is your objective.

Another way to get the horizontal line is to use an XY Scatter series instead of a line series, and apply horizontal error bars. For the XY series' X values, just use 1, 2, 3, ..., N, where N is the number of categories in the stacked series. Excel will probably want to put the XY series onto the secondary axis, but you can overrule this. Use the error bar style without the end caps.

The error bar length is something you'll need to experiment with. The entire distance from the center of one stack to the next is 1, so error bars of length 0.5 will reach from the center of the stack (where the XY point is) in both directions to the middle of the gap between adjacent stacks. This is probably too large, so you can shrink it. The stacked columns themselves are 0.4 wide by default (since the gap width of 150 and the bar width of 100 totals 250, and 100/250 = 0.4) If you use 0.2 as your error bar length, the error bars will reach as far as the edge of the bar.