How to get Actuals vs plan vs forecast

[Pallavi_m]

Hi team,

I have a table with columns like this:

I want to compare actual vs forecast vs plan on a line and stacked column chart, in a way to have columns of actual,forecastand plan separately but not stacked on a column.

Year	Month	Actual sales	ForecastSales	PlanSales
2022	1	50	0	0
2022	2	60	0	0
2022	3	70	0	0
2022	4	110	0	46
2022	5	140	0	46
2022	6	210	0	46
2022	7	317	0	56
2022	8	945	0	202
2022	9	309	0	246
2022	10	312	0	266
2022	11	313	0	574
2022	12	313	146	792

Help is appreciated.

Thanks

[v-xiaosun-msft · Accepted solution]

Hi @Pallavi_m ,

Do you mean that you want to show "actual", "forecast", "plan" in three columns? If so, I suggest that you can use a line and clustered column chart as below.

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.