I've been asked to create a bar chart that shows 4 values: Prior Year, Actual, Forecasted, and Goal. The request is that the Actual and Forecasted amounts would stack on top of each other for easier comparison but I'm struggling to find a chart type that will support this.
I looked into the Grouped & Stacked bar chart option but it doesn't exactly fit the need. Has anyone been able to create a chart like this? If so, how did you accomplish it and how was your dataset structured?