Explore BrainMass
Share

stacked column charts

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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
https://brainmass.com/computer-science/data/stacked-column-charts-152102

Attachments

Solution Preview

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 ...

Solution Summary

Assistance with stacked column charts is provided in the solution.

$2.19