Can I use a range and a custom list at the same time when I am defining X o Y values of a Chart ?

Visitor

I want to obtain the next result (orange series):

borismario_0-1612371623535.png

 

I can do it using the next table:

 

HoursRoom Temperature
7.5-30
823
8.523
9100
  
24.5100
2523
25.523
26-30
  
33-30
33.523
3423
34.550

 

But my doubt is:

¿Can I obtain the same result using the ranges + a custom blank list/point in 'Series X values' and 'Series Y values'?

 

Example of this problem:

Tables

 FGHIJKLM
4HoursRoom Temperature HoursRoom Temperature HoursRoom Temperature
57.5-30 24.5100 33-30
6823 2523 33.523
78.523 25.523 3423
89100 26-30 34.550

Error obtained when I try to add a custom blank point

Series X Values:

=(Sheet1!$F$5:$F$8,{},Sheet1!$I$5:$I$8,{},Sheet1!$L$5:$L$8)

Series Y Values:

=(Sheet1!$G$5:$G$8,{},Sheet1!$J$5:$J$8,{},Sheet1!$M$5:$M$8)

borismario_1-1612372860047.png

borismario_4-1612373354201.png

 

 

 

 

 

1 Reply

@borismario Perhaps not the prettiest solution, but the chart in the attached file looks like the one in your first picture.