Excel chart advanced option

%3CLINGO-SUB%20id%3D%22lingo-sub-2740905%22%20slang%3D%22en-US%22%3EExcel%20chart%20advanced%20option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2740905%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20a%20table%20as%20shown%20below.%20The%20intersecting%20values%20represent%20the%20load%20factor.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%22384%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%20height%3D%2220%22%3EC%20%2F%20phi%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E30%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E35%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E40%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E45%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E50%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E5%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1.17%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1.14%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1.05%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1.1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E15%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1.01%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1.05%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1.1%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1.14%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E25%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1.24%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1.29%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1.33%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1.33%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1.43%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E35%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1.43%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1.48%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1.55%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1.62%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1.55%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ean%20need%20a%20graph%20something%20like%20this%20as%20below%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22WSPSushank_0-1631296288775.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F309655i00BB8C67AAD2CC1B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22WSPSushank_0-1631296288775.png%22%20alt%3D%22WSPSushank_0-1631296288775.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHow%20could%20it%20be%20possible%20in%20excel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%2C%3C%2FP%3E%3CP%3ESushank%20Dani%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2740905%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello,

 

I've a table as shown below. The intersecting values represent the load factor.

 

C / phi3035404550
51.171.1411.051.1
1511.011.051.11.14
251.241.291.331.331.43
351.431.481.551.621.55

 

an need a graph something like this as below - 

 

WSPSushank_0-1631296288775.png

How could it be possible in excel?

 

Thanks in advance.

 

Best Regards,

Sushank Dani

0 Replies