Forum Discussion
Solved
Excel Chart Several Y values against one X Value
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 ma...
SamFares Perhaps like in the attached workbook.
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.
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.
