If your two charts contain different types of data, you can't combine the two charts into one. If both charts have a numeric 'Y' axis, Excel actually will allow you to perform the task, but the. Combination Charts (Combo) in Excel Examples #1 Step 1:-. Select the entire table to be plotted on the chart. As shown in the below screenshot, select the data table, then go to the insert tab in the ribbon and select. Now select the clustered Column excel chart in the. To make the chart easier to read, Excel allows us to add a secondary axis for the chart, here’s how you add a secondary axis for the combination chart in Excel. In the combination chart, click the line chart, and right click or double click, then choose Format Data Series from the text menu, see screenshot: 2. Create a chart sheet that you want to place all embedded charts into it. Then select your first chart that you want to move it to the chart sheet, and then right click, choose Move Chart from the context menu, see screenshot: 3.

In this example we have data from some water pump. We were observed 2 variables (kW and water volume). So there are two data series measured in time, but in different time intervals. First measurement started at 10:00 and continued at 5 minute intervals (left table). Second measurement started at 10:13:30 and continued at half minute intervals (right table). We want Excel to show relationship between these two data series in one chart.

How to show these tables in one chart?

Solution

Merge

Step 1

Make a XY Scatter chartwith smooth lines. Data source is table one (A1:B11).

Step 2

Add new data series into this chart.

Go to the Chart Tools (Options), choose Select Data

and then choose button “Add” to add new series (Legend Entries).

Now you must edit series window.

The first item (Series name) is cell “Water volume”, the second item (Series X values) is column with time and the third item (Series Y values) is column with volume values.

Now we have two data series in one chart.

This is not very useful view. Both of data series share one Y-axis. In the next step we split them into two Y-axes.

Step 3

Right click on one of the data series (line) and choose “Format data series”.

Now switch “Plot Series On” to Secondary Axis.

Excel adds another Y-axis to the chart. Now you can see the relationship between data. Values from the first table are on the right Y-axis and the line of them is blue. Values from the second table are on the left Y-axis and the line is red.

Watch this in video

« Running total for multiple items solved by array formula

Merge Two Charts In Excel

  1. wanted to combine below 2 tables into one chart

    Date 28-Nov-20
    Program IN Closed WIP Auto Manual
    G2G 32 39 1 10 21
    R2O 10 10 0 10 0
    HyperWan 7 7 0 7 0
    SDWan 0 0 0 0 0
    Monarch 0 0 0 0 0

    Date 5-Dec-20
    Program IN Closed WIP Auto Manual
    G2G 132 106 2 45 89
    R2O 11 11 0 11 0
    HyperWan 28 28 0 28 0
    SDWan 0 0 0 0 0
    Monarch 0 0 0 0 0

  2. I have 3 tables with shared data. What is the procedure for that?

  3. How can I design the graph when I have multiple data tables (2 and more)? It should be one graph with all data together.

  4. How to create Excel chart when tables are sharing one column. Nice and simple solution. It was always big issue for me. I have 2 data tables and I want to join tables into one chart in Excel.

Coments are closed

Most Viewed Posts

  • The Big Bang Theory Amazon Prime
  • Rust Green Card
  • Browsers Similar To Tor

Scroll to top