Creating Charts > Multi Series Stacked Chart

In this section we will show you how to create a Multi Series Stacked chart to compare the quarterly cost incurred by a manufacturing company for two consecutive years. Like the stacked chart which we created in the last section of this module - this chart will also help the audience determine the fixed cost and the variable cost which constitute the total cost. For creating this chart we will use some concepts that have been described in detail in the 'Your First Chart' section - so, we recommend that you go through that section first.

Following data table will be used for creating the multi series stacked chart:

2008 2007
Quarter Fixed Cost Variable CostFiced CostVariable Cost
Quarter 1$12,000$8,000$10,200 $4,500
Quarter 2$11,500$9,000$10,500 $7,500
Quarter 3$12,500$9,000$10,000$6,500
Quarter 4$10,900$8,300$10,500$7,200

The following steps will guide you through the process of creating a multi series stacked chart:

  1. In the 'Data Grid' screen - create a table with 5 columns and 4 rows and fill in the data by referring the data table (above).
  2. Designate column 'A' as categories and column 'B', 'C', 'D', and 'E' as series. In the lower portion of the 'Data Grid' screen - name the series in the following manner:
    • Column B - Fixed Cost for 2008
    • Column C - Variable Cost for 2008
    • Column D - Fixed Cost for 2007
    • Column E - Variable cost for 2007
    Finally, set a distinct color fo each series column, your 'Data Grid' screen should resemble the picture (below).

  3. Switch to the 'Chart Selection' screen and select the 'Multi Column' chart option from the 'Stacked Chart' category.
  4. Since we have selected the multi column stacked chart as the chart type; a 'Group Column' section will be displayed in the 'Chart Options' screen'.

    In the 'Group Column' section select column 'B' and column 'C' using Ctrl+Click and then click the 'Make group' button. Note - that both column 'B' and 'C' have been grouped together as 'Group 1'. Repeat the same process with column 'C' and 'D' - they would be grouped together as 'Group 2'.
  5. '

  6. In the 'Titles & Axis Names' section - enter 'Quarters' in the 'xAxisName' field and 'Total Cost' in the 'yAxisName'field.
  7. Switch to the 'General Options'screen by clicking the 'Chart Options' tab. Enter 'myfirstmsschart' in the 'Chart Name' field and set the height and width of the chart to 400 pixels and 300 pixels respectively by entering the values in their respective fields.
  8. In the 'Caption, Subcaption' panel - enter 'Quarterly Cost Analysis' in the 'Caption' field and 'For the year 2007 and 2008' in the 'Subcaption'field.
  9. Check the 'Show Advanced Options' check box which is located in the upper portion of the 'General Options' screen. Now, go to the 'Number Formatting and Scaling' panel and enter '$' into the 'Number Prefix' field.
  10. Preview the chart using 'Open Preview' button and then click 'Ok' to embed the chart into your web page.

You can now open your web page in a browser to see your first multi series stacked chart in action.