Two graphs in one chart, but with different number of values

I have values for every five minute from 10:00 to 13:55 (10:00 am to 01:55 pm) that I have put in a chart. The values vary between 450 and 100. In the same chart I also want an other graph. But here I only have vaules for 11:00, 11:15, 11:30, 11:45, 12:30, 12:45, 13:20 and 13:45. These values are between 5000 and 13000.

How can I get the values for the second graph above the correct time?

If I try putting the second values in the chart, the graph only goes from 10:00 to 10:35.

Hello,

What chart type are you using? An XY Scatter chart will put the values of different series in the appropriate locations.

Post a workbook with a few rows of dummy data to illustrate your challlenge. Please don't post your original file with thousands of rows.

kia ora,

Originally Posted by kakapoo

Hello,

What chart type are you using? An XY Scatter chart will put the values of different series in the appropriate locations.

Post a workbook with a few rows of dummy data to illustrate your challlenge. Please don't post your original file with thousands of rows.

kia ora,

I tried to use a line chart, which I prefer, but really any chart that could ilustrate how the two graphs are related would do. The only option I see myself is to make two charts, but it would be a lot easier to see the connection if the graphs were in the same chart.

Here I have tried to make an example of the challenge.

Hello,

step by step:

click an empty cell on your worksheet.
click Insert ribbon > (Charts section) Scatter drop down > Scatter with straight lines
with the new, empty chart selected, click "Select data" on the Chart Tools / Design ribbon
Click Add
Select these values for the three boxes:

Chart series name -- Click C1
Series X values -- select ='Ark1'!$B$2:$B$14
Series Y values -- delete what's in the box and select ='Ark1'!$C$2:$C$14
click OK

Click "Add"
Chart series name -- Click D1
Series X values -- select ='Ark1'!$B$2:$B$14
Series Y values -- delete what's in the box and select ='Ark1'!$D$2:$D$14
click OK

Click the button "Hidden and empty cells"
Select "Connect data points with lines" and hit OK
Hit OK

The result should look like the attached.

Kia ora,

Thank you so much! You saved my bachelor.