• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Chart Question

R

rjacmuto32

Member
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?
 
Rjacmuto32


Firstly, Welcome to the Chandoo.org Forums


Excel doesn't allow you to do what your trying to do.


You have two options


Add another series to the Target or Left Axis and chanfge it to a Stacked Column Chart

Make the second series very small

Make the outline of the Target series None

Make the outline of the New series Black etc

It will appear as a Black line across the top of the Column


Second option is to use Error bars

Select your series and remove outline format

Add an error bar, Chart Tools, layout Error Bars and set them to Plus with a Fixed value of zero

It doesn't have as many formating options as the first method
 
You must log in or register to reply here.
Back
Top