Hi Everyone,
I am trying to create a specific graph but I am not sure how to do this in excel.
I want to create a combo stacked area chart in excel. With the combo part to be a horizontal-ish line (like a trend line but not) plotting specific values. The values I want for this line are in the column highlighted yellow. In the workbook I have uploaded, I have included a stacked area graph (what I would like but just without the line), my best attempt at creating the combo stacked area chart, and finally, a picture of the graph style I would like (not my actual values in there though). My issue with my best attempt is that it doesn't feel like the right way to make the graph, because I have had to manipulate the values in the yellow column (the manipulated values are in a column called "my attempt values"). Also, in my best attempt, I don't like that it isn't just a line but a polygon.
Note: the line I would like won't always be in the middle of the stacked areas, sometimes it will be above the areas completely.
I'm not sure if creating this graph is possible or not in excel but I thought this would be the place to ask.
Thank you so much in advance for any help you are able to offer me.
Bookmarks