Hi guys, I’m trying to create a bar chart which shows the data for several months (m1, m2, m3 etc). For each month I want to show two bars, the first bar being ‘budget’ and has a single value. The second bar is ‘actual’ and is a stacked bar made up of two values ‘salesman1’ and ‘salesman2’. This if salesman1 and salesman2 add to more than budget you can see as a team they beat the budget and also who contributes what to try total.
Example data
m1: budget 200; salesman1 50; salesman2 125
m1: budget 180; salesman1 50; salesman2 175
m1: budget 160; salesman1 50; salesman2 110
Thanks in advance