Two tables with common column displayed in one chart

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.

Tables with data series

How to show these tables in one chart?


Step 1

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

Scatter step1

Step 2

Add new data series into this chart.

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

Select data ribbon

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

Select data dialog

Now you must edit series window.

Add new data series

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.

Selected data with new series

Now we have two data series in one chart.

After inserting the second table

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”.

Format data series choose

Now switch “Plot Series On” to Secondary Axis.

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.

Two data series in one chart

Watch this in video


Add a comment »5 comments to this article

  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. I need 3 axis in one graph. Is it possible?


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


  5. 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.


Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress