Hello,
I'm having trouble creating a combination chart with clustered and stacked columns. I've attached a test file representative of data I am using. What I would like to accomplish is for the data to result in 5 columns appearing in a clustered manner for each year 2016-19. Only the last two columns for each year should be stacked columns representing the totals of Estimates and Actuals. In the attached chart, the Estimates and Actuals are all included in a single stacked column. I'd like for these to appear as two separate stacked columns, one for Estimate and one for Actuals.
Greatly appreciate any help!
Bookmarks