I am having a difficult time with stacked column charts - if anyone can assist, I would be grateful.
a. Create a stacked column chart that shows the total number of admissions for each region and the contribution of each region within each quarter. Create this chart in its own chart sheet with an appropriate name.
b. Create a stacked column chart showing the total number of admissions for each quarter and the contribution of each region within each quarter. Create this chart in its own chart sheet with an appropriate name.
See the attached file.© BrainMass Inc. brainmass.com March 21, 2019, 3:26 pm ad1c9bdddf
See Excel spreadsheet for final charts, that you can modify.
Step 1: Insert -> Chart: Column is the first choice in the chart type, the sub-type is top row, middle graph. Click on Next
Step 2: Click on the data range tab if it doesn't already show and then click on the grey square in the data ...
Assistance with stacked column charts is provided in the solution.