Creating Charts > Stacked Chart

In this section we will show you how to create a stacked chart to shows the total costs incurred by a manufacturing company for the four quarters of the last financial year. The stacked chart will show the fixed costs and the variable costs as constituents of the total costs. 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.

We are going to use the following data table for this chart:

Quarter Fixed Cost Variable Cost
Quarter 1 $12,000 $8,000
Quarter 2 $11,500 $7,500
Quarter 3 $12,500 $9,000
Quarter 4 $10,900 $8,300

The following steps will guide you through the process of creating a Stacked Chart:

  1. In the 'Data Grid' tab create a table with 3 columns and 4 rows. Enter data into the table by referring to the data table (above).
  2. Designate column A as 'Categories', and column 'B' and 'C' as Series.
  3. In the lower section of the 'Data Grid' screen - name column 'B' as 'Fixed Costs' and column 'C' as 'Variable Costs'. And choose a different color for each of the series. Once you have created the table and designated categories and series - your 'Data Grid' screen should look similar to the picture (below).
  4. Switch to the 'Chart Selection' screen and select a 'Column' chart option from the 'Stacked Charts' category.
  5. In the 'Titles & Axis Names' panel; enter 'Quarter' in the 'xAxisName' field and 'Total Costs' in the 'yAxisName' field.
  6. Switch to the 'General Options' tab and set the 'Chart Name' as 'myfirstStackedChart' and specify the desired width and height of the chart in their respective fields.
  7. In the Caption, Subcaption panel - provide the caption and sub caption for the chart in their respective fields. For this chart we will provide 'Quarterly Cost Analysis' as the caption, and 'For the Year 2008' as the sub caption..
  8. 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.
  9. Your chart is now ready; preview it using the 'Open Preview' button and then click 'Ok' to embed your chart into your web page.

You may now open the page in a browser to see your first stacked chart in action.