Like your pic, except without the Turnover 2015. I'd like the 3 bar charts to be side by side. Is there a workaround? Also, does the 2016 Turnover figure include the 2016 TO figure? The scale seems to indicate that it has summed both TO and Turnover for 2016.
Hi Ana Yin,
I am trying to do that but I am getting stacked bar in one sheet.
If you make 2 sheet for Turnover for 2016 then you can able to show your desired output on dashboard level.
You have to add horizontal container and drag two sheet 1 and sheet 2 in horizontal container and removed borders.
Please refer screenshot.
Please check attached sample workbook for same.
I hope this will work for you.
Thanks and regards,
1 of 1 people found this helpful
The client is asking me to compare CY, PY and the target (secondary source) by Month, Quarter, Half Yr and Full Yr so guess I'll need to find a way to make it work on the sheet itself
Thanks for the effort!