Round Ends on Bar Charts

[GuyGadois]

Last year I changed half of my bar charts to have rounded ends instead of the squared off ends and I can't figure out how to do this on all the remaining charts. I am running Excel 2007 for PC.

Any help is much appreciated.

Guy

 

[pgc01]

Hi

Try the following:

- draw a rounded rectangle in the worksheet

Inser->Shapes->Rounded Rectangle

- Copy the shape
- click on one of the bars in the series. All the bars in the series will be selected
- paste

 

[GuyGadois]

Thanks for the answer. That works to an extent but messes up the formatting. I accomplished it a different way that seemed easy at the time. Maybe I did it in Excel 2003?

Guy

 

[Andy Pope]

If it was xl2007 then you can set the Border Style Join type to Round.
You will have to thicken the line in order to see the effect.

 

[GuyGadois]

If it was xl2007 then you can set the Border Style Join type to Round.
You will have to thicken the line in order to see the effect.

Well, I tried that and it didn't get the same results. Here is what I did in the past that I can't seem to duplicate.

Any help is appreciated.

Guy

 

[Andy Pope]

Are you sure that it is a column chart?
Did you use Line with error bars, and it is the thick error bars that have the rounded caps.