Notifications
Clear all
Excel Dashboards
2
Posts
2
Users
0
Reactions
85
Views
Topic starter
Hi Mynda,
I was wondering if you could help me out?
I am trying to do a chart with several months from last year and then adding in this month, showing act vs budget. I started the report with just this year and January, and I did what you had advised in our last correspondence to do a column overlap making the budget the column with no fill. When I include a month from last year, I now have 4 columns for each customer, when I try to overlap the correct month with the correct actual they all merge into one box, and I really want one for each month. How do i do this
Thanks for your help
Ann
Posted : 22/01/2020 4:52 pm
Hi Ann,
Can you please upload a sample Excel file showing the issue, it's difficult to visualise your scenario and data layout.
Thanks,
Mynda
Posted : 23/01/2020 1:38 pm