Discussion Excel Chart Several Y values against one X Value in Excel
https://techcommunity.microsoft.com/t5/excel/excel-chart-several-y-values-against-one-x-value/m-p/1659739#M74698
<P>Hello,</P><P> </P><P>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....</P><P>I attached the excel sheet.</P><P>Thank you!</P><P>Sam</P><P> </P><TABLE border="0" width="128" cellspacing="0" cellpadding="0"><TBODY><TR><TD width="64" height="19">J71</TD><TD width="64">5</TD></TR><TR><TD height="19">J71</TD><TD>4</TD></TR><TR><TD height="19">J71</TD><TD>8</TD></TR><TR><TD height="19">J71</TD><TD>9</TD></TR><TR><TD height="19">J72</TD><TD>10</TD></TR><TR><TD height="19">J72</TD><TD>7</TD></TR><TR><TD height="19">J72</TD><TD>6</TD></TR><TR><TD height="19">J72</TD><TD>3</TD></TR></TBODY></TABLE>Fri, 11 Sep 2020 23:38:51 GMTSamFares2020-09-11T23:38:51ZExcel Chart Several Y values against one X Value
https://techcommunity.microsoft.com/t5/excel/excel-chart-several-y-values-against-one-x-value/m-p/1659739#M74698
<P>Hello,</P><P> </P><P>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....</P><P>I attached the excel sheet.</P><P>Thank you!</P><P>Sam</P><P> </P><TABLE border="0" width="128" cellspacing="0" cellpadding="0"><TBODY><TR><TD width="64" height="19">J71</TD><TD width="64">5</TD></TR><TR><TD height="19">J71</TD><TD>4</TD></TR><TR><TD height="19">J71</TD><TD>8</TD></TR><TR><TD height="19">J71</TD><TD>9</TD></TR><TR><TD height="19">J72</TD><TD>10</TD></TR><TR><TD height="19">J72</TD><TD>7</TD></TR><TR><TD height="19">J72</TD><TD>6</TD></TR><TR><TD height="19">J72</TD><TD>3</TD></TR></TBODY></TABLE>Fri, 11 Sep 2020 23:38:51 GMThttps://techcommunity.microsoft.com/t5/excel/excel-chart-several-y-values-against-one-x-value/m-p/1659739#M74698SamFares2020-09-11T23:38:51ZRe: Excel Chart Several Y values against one X Value
https://techcommunity.microsoft.com/t5/excel/excel-chart-several-y-values-against-one-x-value/m-p/1660135#M74706
<P><LI-USER uid="351459"></LI-USER> Perhaps like in the attached workbook.<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2020-09-12 at 07.27.36.png" style="width: 475px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/217952i3C3D4C92F1284601/image-dimensions/475x228?v=1.0" width="475" height="228" role="button" title="Screenshot 2020-09-12 at 07.27.36.png" alt="Screenshot 2020-09-12 at 07.27.36.png" /></span></P>Sat, 12 Sep 2020 05:28:13 GMThttps://techcommunity.microsoft.com/t5/excel/excel-chart-several-y-values-against-one-x-value/m-p/1660135#M74706Riny_van_Eekelen2020-09-12T05:28:13ZRe: Excel Chart Several Y values against one X Value
https://techcommunity.microsoft.com/t5/excel/excel-chart-several-y-values-against-one-x-value/m-p/1660175#M74707
<P><LI-USER uid="351459"></LI-USER> </P><P> </P><P>Another solution is use a J## label with the chart</P><P>create the values of the columns without the J, only 71 and 72</P><P>then plot a scatter plot.</P><P>in the Label option add J##, which means what ever is the number put a J in front of it </P><P>see the photo</P>Sat, 12 Sep 2020 06:19:03 GMThttps://techcommunity.microsoft.com/t5/excel/excel-chart-several-y-values-against-one-x-value/m-p/1660175#M74707Ramiz_Assaf2020-09-12T06:19:03ZRe: Excel Chart Several Y values against one X Value
https://techcommunity.microsoft.com/t5/excel/excel-chart-several-y-values-against-one-x-value/m-p/1660215#M74710
<P><LI-USER uid="351459"></LI-USER> </P><P>Charting is often a matter of 'smoke and mirrors'</P><P>The picture shows error bars used to define the values and a separate series used to provide labels for the axis.</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 999px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/217954i2E5E21C403C9295C/image-size/large?v=1.0&px=999" role="button" title="image.png" alt="image.png" /></span></P><P>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.</P>Sat, 12 Sep 2020 09:19:50 GMThttps://techcommunity.microsoft.com/t5/excel/excel-chart-several-y-values-against-one-x-value/m-p/1660215#M74710Peter Bartholomew2020-09-12T09:19:50ZRe: Excel Chart Several Y values against one X Value
https://techcommunity.microsoft.com/t5/excel/excel-chart-several-y-values-against-one-x-value/m-p/1661011#M74755
<P>Thank you so much<LI-USER uid="403176"></LI-USER> </P><P>Appreciate your assistance!</P><P> </P><P>Sam</P>Sat, 12 Sep 2020 22:50:18 GMThttps://techcommunity.microsoft.com/t5/excel/excel-chart-several-y-values-against-one-x-value/m-p/1661011#M74755SamFares2020-09-12T22:50:18ZRe: Excel Chart Several Y values against one X Value
https://techcommunity.microsoft.com/t5/excel/excel-chart-several-y-values-against-one-x-value/m-p/1661012#M74756
<P>Thanks a lot <LI-USER uid="746148"></LI-USER> </P><P>Appreciate your help!</P>Sat, 12 Sep 2020 22:50:53 GMThttps://techcommunity.microsoft.com/t5/excel/excel-chart-several-y-values-against-one-x-value/m-p/1661012#M74756SamFares2020-09-12T22:50:53ZRe: Excel Chart Several Y values against one X Value
https://techcommunity.microsoft.com/t5/excel/excel-chart-several-y-values-against-one-x-value/m-p/1661013#M74757
<P>Thank you <LI-USER uid="214174"></LI-USER> </P><P>Appreciate your assistance!</P><P> </P><P> </P><P>Sam</P>Sat, 12 Sep 2020 22:52:38 GMThttps://techcommunity.microsoft.com/t5/excel/excel-chart-several-y-values-against-one-x-value/m-p/1661013#M74757SamFares2020-09-12T22:52:38Z