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

%3CLINGO-SUB%20id%3D%22lingo-sub-2113033%22%20slang%3D%22en-US%22%3ECan%20I%20use%20a%20range%20and%20a%20custom%20list%20at%20the%20same%20time%20when%20I%20am%20defining%20X%20o%20Y%20values%20of%20a%20Chart%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2113033%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20obtain%20the%20next%20result%20(orange%20series)%3A%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22borismario_0-1612371623535.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F251980iA8EB4857DBC3AB0E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22borismario_0-1612371623535.png%22%20alt%3D%22borismario_0-1612371623535.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20do%20it%20using%20the%20next%20table%3A%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-60px%22%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22193%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22109px%22%20height%3D%2257px%22%3EHours%3C%2FTD%3E%3CTD%20width%3D%22155px%22%20height%3D%2257px%22%3ERoom%20Temperature%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22109px%22%20height%3D%2230px%22%3E7.5%3C%2FTD%3E%3CTD%20width%3D%22155px%22%20height%3D%2230px%22%3E-30%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22109px%22%20height%3D%2230px%22%3E8%3C%2FTD%3E%3CTD%20width%3D%22155px%22%20height%3D%2230px%22%3E23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22109px%22%20height%3D%2230px%22%3E8.5%3C%2FTD%3E%3CTD%20width%3D%22155px%22%20height%3D%2230px%22%3E23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22109px%22%20height%3D%2230px%22%3E9%3C%2FTD%3E%3CTD%20width%3D%22155px%22%20height%3D%2230px%22%3E100%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22109px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22155px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22109px%22%20height%3D%2230px%22%3E24.5%3C%2FTD%3E%3CTD%20width%3D%22155px%22%20height%3D%2230px%22%3E100%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22109px%22%20height%3D%2230px%22%3E25%3C%2FTD%3E%3CTD%20width%3D%22155px%22%20height%3D%2230px%22%3E23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22109px%22%20height%3D%2230px%22%3E25.5%3C%2FTD%3E%3CTD%20width%3D%22155px%22%20height%3D%2230px%22%3E23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22109px%22%20height%3D%2230px%22%3E26%3C%2FTD%3E%3CTD%20width%3D%22155px%22%20height%3D%2230px%22%3E-30%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22109px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22155px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22109px%22%20height%3D%2230px%22%3E33%3C%2FTD%3E%3CTD%20width%3D%22155px%22%20height%3D%2230px%22%3E-30%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22109px%22%20height%3D%2230px%22%3E33.5%3C%2FTD%3E%3CTD%20width%3D%22155px%22%20height%3D%2230px%22%3E23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22109px%22%20height%3D%2230px%22%3E34%3C%2FTD%3E%3CTD%20width%3D%22155px%22%20height%3D%2230px%22%3E23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22109px%22%20height%3D%2230px%22%3E34.5%3C%2FTD%3E%3CTD%20width%3D%22155px%22%20height%3D%2230px%22%3E50%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20my%20doubt%20is%3A%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%C2%BFCan%20I%20obtain%20the%20same%20result%20using%20the%20ranges%20%2B%20a%20custom%20blank%20list%2Fpoint%20in%20'Series%20X%20values'%20and%20'Series%20Y%20values'%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%20of%20this%20problem%3A%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-30px%22%3ETables%3C%2FP%3E%3CTABLE%20width%3D%22678%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EF%3C%2FTD%3E%3CTD%20width%3D%2298%22%3EG%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EH%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EI%3C%2FTD%3E%3CTD%20width%3D%2298%22%3EJ%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EK%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EL%3C%2FTD%3E%3CTD%20width%3D%2298%22%3EM%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3EHours%3C%2FTD%3E%3CTD%20width%3D%2298%22%3ERoom%20Temperature%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EHours%3C%2FTD%3E%3CTD%20width%3D%2298%22%3ERoom%20Temperature%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EHours%3C%2FTD%3E%3CTD%20width%3D%2298%22%3ERoom%20Temperature%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E7.5%3C%2FTD%3E%3CTD%3E-30%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E24.5%3C%2FTD%3E%3CTD%3E100%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E33%3C%2FTD%3E%3CTD%3E-30%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E8%3C%2FTD%3E%3CTD%3E23%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3CTD%3E23%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E33.5%3C%2FTD%3E%3CTD%3E23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E7%3C%2FTD%3E%3CTD%3E8.5%3C%2FTD%3E%3CTD%3E23%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E25.5%3C%2FTD%3E%3CTD%3E23%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E34%3C%2FTD%3E%3CTD%3E23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E8%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3E100%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E26%3C%2FTD%3E%3CTD%3E-30%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E34.5%3C%2FTD%3E%3CTD%3E50%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%20class%3D%22lia-indent-padding-left-30px%22%3EError%20obtained%20when%20I%20try%20to%20add%20a%20custom%20blank%20point%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-60px%22%3ESeries%20X%20Values%3A%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-60px%22%3E%3D(Sheet1!%24F%245%3A%24F%248%2C%3CFONT%20color%3D%22%23FF9900%22%3E%3CSTRONG%3E%7B%7D%2C%3C%2FSTRONG%3E%3C%2FFONT%3ESheet1!%24I%245%3A%24I%248%2C%3CSTRONG%3E%3CFONT%20color%3D%22%23FF9900%22%3E%7B%7D%2C%3C%2FFONT%3E%3C%2FSTRONG%3ESheet1!%24L%245%3A%24L%248)%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-60px%22%3ESeries%20Y%20Values%3A%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-60px%22%3E%3D(Sheet1!%24G%245%3A%24G%248%2C%3CSTRONG%3E%3CFONT%20color%3D%22%23FF9900%22%3E%7B%7D%2C%3C%2FFONT%3E%3C%2FSTRONG%3ESheet1!%24J%245%3A%24J%248%2C%3CFONT%20color%3D%22%23FF9900%22%3E%3CSTRONG%3E%7B%7D%2C%3C%2FSTRONG%3E%3C%2FFONT%3ESheet1!%24M%245%3A%24M%248)%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-60px%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22borismario_1-1612372860047.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F251997i9B0824018BEDE97F%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22borismario_1-1612372860047.png%22%20alt%3D%22borismario_1-1612372860047.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-60px%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22borismario_4-1612373354201.png%22%20style%3D%22width%3A%20615px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F252004i2EEE0CFA25F36D86%2Fimage-dimensions%2F615x367%3Fv%3D1.0%22%20width%3D%22615%22%20height%3D%22367%22%20role%3D%22button%22%20title%3D%22borismario_4-1612373354201.png%22%20alt%3D%22borismario_4-1612373354201.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2113033%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2113630%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20use%20a%20range%20and%20a%20custom%20list%20at%20the%20same%20time%20when%20I%20am%20defining%20X%20o%20Y%20values%20of%20a%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2113630%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F249786%22%20target%3D%22_blank%22%3E%40borismario%3C%2FA%3E%26nbsp%3BPerhaps%20not%20the%20prettiest%20solution%2C%20but%20the%20chart%20in%20the%20attached%20file%20looks%20like%20the%20one%20in%20your%20first%20picture.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.