In 'Sales & Actual Cost' Chart, I would like 'Budgeted Cost' and 'Additional Cost' to be a stacked column.
Rearrange the data in the spreadsheet so you can put additional cost into its own data series and change the chart type to a stacked column chart:
1) chart data table:
2) Select these 6 cells and insert a stacked column chart. Then format chart elements as desired.
I wasn't sure exactly what you wanted to do in combining the gross margin % and original vs adjusted gross margin charts. As a guess, it looks like you want to somehow communicate both the gross margin values and the % margin values in the same chart. Starting with the "Original vs. Adjusted Gross Margin" chart, I:
1) Change the chart type to 2D stacked column (because I hate trying to read 3D charts -- see this essay for why: https://peltiertech.com/the-perils-of-being-in-3d/ )
2) Delete the current data labels (I will read the gross margin values directly off the chart).
3) Using Rob Bovey's free XY chart labeler add-in (your profile says you are using Excel 2010, so this functionality is not native to our versions of Excel) and use the values in B7 and B8 as the data labels for each data series.
4) Using the Select source data dialog, change the plot order of the two data series (to the right of the "Remove" button in the Legend Entries (Series) portion of the dialog is a pair of up/down arrows which you can use to move a series up or down in the plot order).
Is that close to what you are trying to do?
Bookmarks