---
schema_version: "1"
id: b76f90d2ae29b04efdd7e1e67a8e9e6af83b7873ce1b9dd07834ea179d9448bb
title: Show Multiple Sets of Data in One Chart
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/reports_combination_charts_using.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.reports_combination_charts_using.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 6751790e7c5a63ade9e5506e050cdcc5599aec9d686bfced6dbd5c4fbc4cf297
description: A combination chart plots multiple sets of data on a single chart. Each set of data is based on a different field, so values are easy to compare. You can also combine certain chart types to present data in different ways in a single chart.
products:
  - Cross Cloud
release: "264"
---
# Show Multiple Sets of Data in One Chart

A combination chart plots multiple sets of data on a single chart. Each set of data is based on a different field, so values are easy to compare. You can also combine certain chart types to present data in different ways in a single chart.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Salesforce Classic and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Essentials</strong>, <strong>Group</strong>, <strong>Professional</strong>, <strong>Enterprise</strong>, <strong>Performance</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Enhanced Folder Sharing</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="vertical-align:top;" id="d13236e91">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d13236e91 ">To create, edit, and delete reports:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d13236e91 ">
              <dl>

                <dt style="font-weight:bold;padding-top:.25rem;">Enhanced Folder Sharing</dt>

                <dd style="padding-left:1.5rem;padding-bottom:.5rem;">Create and Customize Reports <p>AND</p>
                  <p style="margin-bottom:0;">Report Builder</p>
                </dd>

              </dl>
            </td>

          </tr>
        </tbody>
      </table>

For example, as a sales manager, you can display “Pipeline amount” as a line and “Number of open deals” as vertical bars on the same chart.

With combination charts, you can:

- Add a line to an existing line, vertical column, grouped vertical column, or stacked vertical column chart.
- Add a cumulative line to an existing line cumulative chart.
- Add up to three columns to a vertical column chart.
- Add up to three bars to a horizontal bar chart.

In Lightning Experience, to display multiple measures on the same chart, follow these steps:

1. Edit the chart for any report grouped by rows (summary report) or grouped by rows and columns (matrix report).
2. Verify that a summary measure is applied to each of the fields that you want to plot on the Y axis.
3. To add a chart to the report, click **![Toggle Chart](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/analytics/images/rd/rd_chart_toggle.png)**.
4. To edit the chart, click **![Edit Chart](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/analytics/images/rd/rd_settings_gear.png)**.
5. Choose the Bar, Column, or Line chart.
6. The X axis for the chart is the field for the row grouping. If the report is grouped by multiple rows, select the one to use as the X axis.
7. For the Y axis, select a measure field.
8. To display a reference line, click **Show Reference Line** and enter the reference value.
9. If your chart is a line chart and you want to display cumulative values, select **Cumulative**.
10. To add another measure of the same type, click **\+ Measure** and select the measure field to add. For bar chart and column charts, you can add up to 3 additional measures.
11. If your chart is a column chart, you can display the second measure as a line chart. Select **Plot as Line Chart**. To display a separate axis for the line chart on the right, select **Plot on Second Axis**. The measure for the second axis can be different than the measure for the first axis. For example, if the column chart shows Amount, you can add Percentage as a line chart using a second axis.
12. After adding measures and modifying any other settings, click **Run Report** or **Save**.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/images/icon_note.png)

Note

- If you lose access to a field used in a chart, another field can be used in its place. If no other fields are available, the record count is used.
- Don't set both the X axis and Y axis to Auto. If they're both set to Auto, you can’t plot the chart.
- Filtered drilldown doesn't work for combination charts in dashboards.

#### See Also

- [Chart Types](https://help.salesforce.com/s/articleView?id=analytics.chart_types.htm&release=264.0.0&type=5 "You can show data in reports and dashboards in the form of bars, columns, lines, shapes, or other elements. Which is right depends on what the data is about and what you want to show with it.")
- [Add a Chart to a Report](https://help.salesforce.com/s/articleView?id=analytics.reports_builder_charts.htm&release=264.0.0&type=5 "Add a chart to give users a visual way to understand the data in your report.")
- [Combination Chart Examples](https://help.salesforce.com/s/articleView?id=analytics.reports_combination_charts_examples.htm&release=264.0.0&type=5 "Use a combination chart to show multiple values against a single axis range, show two chart types together, or compare two continuous summary values.")