clemoullac
New Member
- Joined
- Jan 14, 2016
- Messages
- 1
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.
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.