Share
Explore BrainMass

stacked column charts

I am having a difficult time with stacked column charts - if anyone can assist, I would be greatful.

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.

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

Help with stacked column charts is given.

$2.19