Purchase Solution

stacked column charts

Not what you're looking for?

Ask Custom Question

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.

Attachments
Purchase this Solution
Solution Summary

Assistance with stacked column charts is provided in the solution.

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

Purchase this Solution
Free BrainMass Quizzes
Basic Networking Questions

This quiz consists of some basic networking questions.

Javscript Basics

Quiz on basics of javascript programming language.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

View More Free Quizzes
Related BrainMass Solutions

  • Male and Female Workers

    Select range G6:H21, on the Insert tab, click Recommended Charts, then open All Charts tab, then click Column, and then click 100% Stacked Column. Use cell references to G6 and H6 for Series names. Select A7:A21 as Horizontal Axis Labels.

  • Plotting Charts and Other Computations using Excel

    Creating the column chart: 1. Column chart can be made by highlighting the entire data set. 2. Go to Insert --> Column. 3. Then select the column chart that you want.

  • Compiling automobile ratings into charts

    Select the rand A3:F8, and then create a stacked column chart. You realize that the data in this chart is not cumulative and that you included the overall ratings by category. You also notice that the chart is located to the side of the data.

  • Gantt Chart Team Formation Duration

    The expert examines Gantt Charts for various tasks in management.

  • Urban and Rural Excel

    All formulas, computations, charts and solutions are in the Excel file.

  • Particular graphs: bar, column, pie, line, XY

    295484 Particular graphs: bar, column, pie, line, XY There are several different types of graphs including bar charts, column charts, pie charts, line charts and XY graphs, to name the most commonly used.

  • Chi square test for Goodness of fit & Association

    In your report, be sure to include the tables with the results of the Chi-square test as well as a chart (a stacked column chart works well) comparing the expected vs. the observed frequencies.

  • Business Statistics: Chi-square Test

    In your report, be sure to include the tables with the results of the Chi-square test as well as a chart (a stacked column chart works well) comparing the expected vs. the observed frequencies.

  • Spreadsheets and Charts/Graphs

    This solution constructs examples of spreadsheets and charts/graphs.

View More Related Solutions