قالب وردپرس درنا توس
Home / Tips and Tricks / How to Create a Combo Chart in Excel

How to Create a Combo Chart in Excel



  Excel Logo

A combination chart in Excel displays two types of charts (such as column and row) in the same chart. They are used to display different types of information in a single chart, such as: B. Actual values ​​for a destination.

This article shows how to create a combo chart that follows the same axis, and mixed types of information display data in a single chart on a different axis.

Inserting a Combination Chart with a Single Axis

In the first example, we will create a combination chart to show the monthly revenue for a target using the following example data. [1

9659003]   Example data for the single-axis combo diagram

You can see that the target value is the same every month. The result shows the data as a straight line.

First, select the range of cells that you want to plot on a graph – A1: C13 in this example. Then click Insert> Insert Combination Chart. Select "Clustered Column – Line".

 Inserting a Clustered Column - Line Diagram

The combination diagram is inserted with both the column and the line on the same axis. As simple as that!

 Combination chart inserted on one axis

You can now continue to improve the diagram, such as: For example, change the chart title. Click the chart title box and begin typing to replace the words "chart title" with something more useful. As you type, the text appears in the formula bar above.

 Change the chart title to a descriptive

Press Enter, and Excel saves the typed text as a chart title. [19659003]   Combination Chart with Title

Inserting Combination Chart with Two Axes

Use the sample data shown below to create a combination chart to show the monthly earnings and the ad budget in the same chart. [19659003]   Sample Data for a Two-Axis Combination Chart

Select range A1: C13. Click Insert> Combination Chart. Select the Clustered Column – Line on Secondary Axis diagram.

 Insert Combination Chart

The inserted chart looks like this.

 Combination Chart with Mixed Data Types

Changing an Existing Chart to a Combination Chart

We looked at two examples of how to create a combination chart from worksheet data, but it may also be useful to edit an existing chart.

Below is a grouped column chart created from The Revenue and Ad budget data.

 Cluster column chart that needs to be changed.

The chart has an axis and you can barely see the ad budget columns in the chart. Change this to a combination chart by creating a secondary axis for the ad budget data and changing the chart type to a line.

First, right-click on the data series you want to change (in this example, the ad budget). , Next, select "Modify Row Chart Type".

 Changing the chart type of a data series

Now select the Secondary Axis check box for the data series for which you want to create an axis. In the Chart Type list, select Line for this series.

 Dialog Box

The chart changes to a combination chart.

 Combination Diagram from Grouped Column Done

Then you can make further improvements to the Combination Diagram. For example, edit the chart title or label the axis.


Source link