We help IT Professionals succeed at work.

Overlapping Bar Chart

dcnkmnarn
dcnkmnarn used Ask the Experts™
on
I've found examples on web that show how to do an overlapping bar chart (with thinner bars in front), by using secondary axis.  Is there a way to do this when the secondary axis is not available (already used).  

My 1st data series is a bar chart on primary axis;  2nd data series is a line chart on secondary axis;  and for my 3rd data series (to be plotted against primary axis) - needs to also be bar chart but with the bars fatter (overlapping) the 1st data series.  

Is this doable (non-vba solution preferred)?  Thanks in advance.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
TracyVBA Developer

Commented:
Can you post a sample file?

Author

Commented:
Sample file attached.  Desired result is to have the blue bars be thinner than the green bars.  Both bar chart data series are on primary axis.  The line chart is using the secondary axis.  Thanks.

Book-1.xlsx
Most Valuable Expert 2011
Top Expert 2011
Commented:
Would this be OK? It uses minus error bars on a line chart, with the errors set to -100% and with the line set to about 15 point width.
Book-1.xlsx

Author

Commented:
rorya:  Yes that would work.  Can you pls walk me thru how to edit that?  Or to see your settings that you mentioned (-100% errors, line at 15 point width)?  Do I apply the error bar to Projection data series itself?  Thanks.

Author

Commented:
rorya:  Took me while to figure out you applied that to the Actual Sales Volume data series.  That is a clever solution.  I assume there's no getting around the legend for Actual Sales Volume not showing a blue square.  Without that legend will still pose a problem.  Any recommendations?  Thanks.
Most Valuable Expert 2011
Top Expert 2011

Commented:
I'll have a go! :)
1. Right-click the series and choose "Change series chart type" and switch to a line chart with no markers.
2. Right-click again, choose Format Data Series and set the Line Color option to None.
3. Click the Layout tab in the Chart Tools section, click the Error Bars dropdown, then choose the 'More error bars options...' button. Choose 'Minus error bars' and set the Percentage to 100%. Then set the Line Color as required, then set the Width in the Line Style section to a large value such as 20.
Job done!
Most Valuable Expert 2011
Top Expert 2011

Commented:
You can add a marker to the series, set it to the flat line style and make it the same size as the error bar width. Not perfect, but better than nothing?