How do you do multiple overlays on a clustered column bar graph?

[clemoullac]

I'm working on a sales volume graph that tries to show four different series plotted over 24 months from Jan15-Dec-16: Actual (Gross), Actual (Net of returned goods), 2016 budget (gross), 2016 budget (net of returned goods).

My goal is to show gross and net numbers on the same bar but separated for actual versus budget. I was able to overlap the gross and net numbers for the 2015 actual volume and for the 2016 budgeted volume by formatting the data series to 100% overlap. However, in January 2016 all of the data (actual gross/net and budget gross/net) shows on one overlapped bar. I tried to insert a picture of what my graph looks like now, but this is my first time posting on this forum (I tried insert picture but couldn't find the URL), so apologies for being a newbie.

Is it possible to show two overlapped bars (Actual and Plan) next to each other for January 2016. I've tried using a secondary axis as well but no luck.

 

[Steve=True]

Hi Clemoullac,

I am not sure I know what you intend to create..

Are you looking for something like this?

how-to-easily-create-a-stacked-clustered-column-chart-in-excel

Steve=True