Forum

Notifications
Clear all

Excel charts

2 Posts
2 Users
0 Reactions
85 Views
(@annc65)
Posts: 3
Active Member
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
(@mynda)
Posts: 4761
Member Admin
 

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
Share: