SOLVED

Excel Chart Several Y values against one X Value

%3CLINGO-SUB%20id%3D%22lingo-sub-1659739%22%20slang%3D%22en-US%22%3EExcel%20Chart%20Several%20Y%20values%20against%20one%20X%20Value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1659739%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20like%20to%20draw%20a%20plot.%20for%20each%20X%20value%20there%20are%20multiple%20Y%20values.%20Is%20there%20a%20chart%20where%20i%20can%20plot%20X%20.%20In%20the%20plot%20i%20would%20like%20to%20see%20one%26nbsp%3B%20J71%20on%20the%20x-axis%2C%20and%20the%20Y%20values%20are%20markers%20lining%20up%20vertically.%20Similarly%20for%20J72%20as%20the%20next%20X-value%20with%20its%20corresponding%20Y-values.%20If%20I%20use%20X-Y%20scatter%20the%20x%20values%20show%20up%20as%201%2C2%2C3..%20but%20I'd%20like%20to%20see%20J71%2CJ72....%3C%2FP%3E%3CP%3EI%20attached%20the%20excel%20sheet.%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3ESam%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%22128%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%20height%3D%2219%22%3EJ71%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3EJ71%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3EJ71%3C%2FTD%3E%3CTD%3E8%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3EJ71%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3EJ72%3C%2FTD%3E%3CTD%3E10%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3EJ72%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3EJ72%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3EJ72%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1659739%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1660135%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Chart%20Several%20Y%20values%20against%20one%20X%20Value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1660135%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F351459%22%20target%3D%22_blank%22%3E%40SamFares%3C%2FA%3E%26nbsp%3BPerhaps%20like%20in%20the%20attached%20workbook.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-09-12%20at%2007.27.36.png%22%20style%3D%22width%3A%20475px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F217952i3C3D4C92F1284601%2Fimage-dimensions%2F475x228%3Fv%3D1.0%22%20width%3D%22475%22%20height%3D%22228%22%20title%3D%22Screenshot%202020-09-12%20at%2007.27.36.png%22%20alt%3D%22Screenshot%202020-09-12%20at%2007.27.36.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1660175%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Chart%20Several%20Y%20values%20against%20one%20X%20Value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1660175%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F351459%22%20target%3D%22_blank%22%3E%40SamFares%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnother%20solution%20is%20use%20a%20J%23%23%20label%20with%20the%20chart%3C%2FP%3E%3CP%3Ecreate%20the%20values%20of%20the%20columns%20without%20the%20J%2C%20only%2071%20and%2072%3C%2FP%3E%3CP%3Ethen%20plot%20a%20scatter%20plot.%3C%2FP%3E%3CP%3Ein%20the%20Label%20option%20add%20J%23%23%2C%20which%20means%20what%20ever%20is%20the%20number%20put%20a%20J%20in%20front%20of%20it%26nbsp%3B%3C%2FP%3E%3CP%3Esee%20the%20photo%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1660215%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Chart%20Several%20Y%20values%20against%20one%20X%20Value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1660215%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F351459%22%20target%3D%22_blank%22%3E%40SamFares%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECharting%20is%20often%20a%20matter%20of%20'smoke%20and%20mirrors'%3C%2FP%3E%3CP%3EThe%20picture%20shows%20error%20bars%20used%20to%20define%20the%20values%20and%20a%20separate%20series%20used%20to%20provide%20labels%20for%20the%20axis.%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%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F217954i2E5E21C403C9295C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EEdit%3A%20I%20have%20since%20used%20a%20named%20formula%20to%20calculate%20the%20x-position%20without%20showing%20it%20on%20the%20worksheet.%26nbsp%3B%20Also%20added%20value%20labels%20at%20the%20centre%20of%20each%20bar.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1661011%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Chart%20Several%20Y%20values%20against%20one%20X%20Value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1661011%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20much%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAppreciate%20your%20assistance!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESam%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hello,

 

I'd like to draw a plot. for each X value there are multiple Y values. Is there a chart where i can plot X . In the plot i would like to see one  J71 on the x-axis, and the Y values are markers lining up vertically. Similarly for J72 as the next X-value with its corresponding Y-values. If I use X-Y scatter the x values show up as 1,2,3.. but I'd like to see J71,J72....

I attached the excel sheet.

Thank you!

Sam

 

J715
J714
J718
J719
J7210
J727
J726
J723
6 Replies
Best Response confirmed by SamFares (Contributor)
Solution

@SamFares Perhaps like in the attached workbook.Screenshot 2020-09-12 at 07.27.36.png

@SamFares 

 

Another solution is use a J## label with the chart

create the values of the columns without the J, only 71 and 72

then plot a scatter plot.

in the Label option add J##, which means what ever is the number put a J in front of it 

see the photo

@SamFares 

Charting is often a matter of 'smoke and mirrors'

The picture shows error bars used to define the values and a separate series used to provide labels for the axis.

 

image.png

Edit: I have since used a named formula to calculate the x-position without showing it on the worksheet.  Also added value labels at the centre of each bar.

Thank you so much@Riny_van_Eekelen 

Appreciate your assistance!

 

Sam

Thanks a lot @Ramiz_Assaf 

Appreciate your help!

Thank you @Peter Bartholomew 

Appreciate your assistance!

 

 

Sam