SOLVED

Excel Chart Several Y values against one X Value

Highlighted
Occasional 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
Highlighted
Best Response confirmed by SamFares (Occasional Contributor)
Solution

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

Highlighted

@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

Highlighted

@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.

Highlighted

Thank you so much@Riny_van_Eekelen 

Appreciate your assistance!

 

Sam

Highlighted

Thanks a lot @Ramiz_Assaf 

Appreciate your help!

Highlighted

Thank you @Peter Bartholomew 

Appreciate your assistance!

 

 

Sam