Scatter chart with multiple data points on one date

[adelk2202]

Hello all! I searched the forum for an answer to my question couldn't find an answer that worked for me but maybe I did not search properly. I am having a hard time creating a scatter chart that works for my data. Perhaps I should choose a different chart type but my boss has specifically requested a scatter chart. Maybe the issue is just in I have my data formatted? I feel like I am making this way more difficult than it is. I am new to this forum so if I have made any stupid mistakes please be kind in correcting me. haha Thank you!


[TABLE="width: 320"]
<tbody>[TR]
[TD="class: xl64, width: 64, align: right"]12/17/17[/TD]
[TD="class: xl64, width: 64, align: right"] 12/18/17[/TD]
[TD="class: xl64, width: 64, align: right"]12/19/17[/TD]
[TD="class: xl64, width: 64, align: right"]12/20/17[/TD]
[TD="class: xl64, width: 64, align: right"]12/21/17[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]174.6[/TD]
[TD="class: xl63, align: right"]175.6[/TD]
[TD="class: xl63, align: right"]181.9[/TD]
[TD="class: xl63, align: right"]174.5[/TD]
[TD="class: xl63, align: right"]176.4[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]174.8[/TD]
[TD="class: xl63, align: right"]177.4[/TD]
[TD="class: xl63, align: right"]182.3[/TD]
[TD="class: xl63, align: right"]172.1[/TD]
[TD="class: xl63, align: right"]175.8[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]175.2[/TD]
[TD="class: xl63, align: right"]177.9[/TD]
[TD="class: xl63, align: right"]183.4[/TD]
[TD="class: xl63, align: right"]165.3[/TD]
[TD="class: xl63, align: right"]175.9[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]184.3[/TD]
[TD="class: xl63, align: right"]180.3[/TD]
[TD="class: xl63, align: right"]174.2[/TD]
[TD="class: xl63, align: right"]175.4[/TD]
[TD="class: xl63, align: right"]173.8[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]184.6[/TD]
[TD="class: xl63, align: right"]183.5[/TD]
[TD="class: xl63, align: right"]173.4[/TD]
[TD="class: xl63, align: right"]177.5[/TD]
[TD="class: xl63, align: right"]174.2[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]185.4[/TD]
[TD="class: xl63, align: right"]179.8[/TD]
[TD="class: xl63, align: right"]175.6[/TD]
[TD="class: xl63, align: right"]180.0[/TD]
[TD="class: xl63, align: right"]173.6[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]175.4[/TD]
[TD="class: xl63, align: right"]175.4[/TD]
[TD="class: xl63, align: right"]173.8[/TD]
[TD="class: xl63, align: right"]177.6[/TD]
[TD="class: xl63, align: right"]175.6[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]175.6[/TD]
[TD="class: xl63, align: right"]177.6[/TD]
[TD="class: xl63, align: right"]174.6[/TD]
[TD="class: xl63, align: right"]182.1[/TD]
[TD="class: xl63, align: right"]175.7[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]175.8[/TD]
[TD="class: xl63, align: right"]180.1[/TD]
[TD="class: xl63, align: right"]174.7[/TD]
[TD="class: xl63, align: right"]183.2[/TD]
[TD="class: xl63, align: right"]175.9[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]181.8[/TD]
[TD="class: xl63, align: right"]178.6[/TD]
[TD="class: xl63, align: right"]177.5[/TD]
[TD="class: xl63, align: right"]168.5[/TD]
[TD="class: xl63, align: right"]174.6[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]183.7[/TD]
[TD="class: xl63, align: right"]182.1[/TD]
[TD="class: xl63, align: right"]182.1[/TD]
[TD="class: xl63, align: right"]165.3[/TD]
[TD="class: xl63, align: right"]174.5[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]183.9[/TD]
[TD="class: xl63, align: right"]183.4[/TD]
[TD="class: xl63, align: right"]183.2[/TD]
[TD="class: xl63, align: right"]167.2[/TD]
[TD="class: xl63, align: right"]175.3[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]182.1[/TD]
[TD="class: xl63, align: right"]183.7[/TD]
[TD="class: xl63, align: right"]170.2[/TD]
[TD="class: xl63, align: right"]174.9[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]183.4[/TD]
[TD="class: xl63, align: right"]184.6[/TD]
[TD="class: xl63, align: right"]172.9[/TD]
[TD="class: xl63, align: right"]175.8[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]183.2[/TD]
[TD="class: xl63, align: right"]184.9[/TD]
[TD="class: xl63, align: right"]172.8[/TD]
[TD="class: xl63, align: right"]176.6[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]180.6[/TD]
[TD="class: xl63, align: right"]175.6[/TD]
[TD="class: xl63, align: right"]169.4[/TD]
[TD="class: xl63, align: right"]175.4[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]182.7[/TD]
[TD="class: xl63, align: right"]174.3[/TD]
[TD="class: xl63, align: right"]168.6[/TD]
[TD="class: xl63, align: right"]172.1[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]183.9[/TD]
[TD="class: xl63, align: right"]175.2[/TD]
[TD="class: xl63, align: right"]168.2[/TD]
[TD="class: xl63, align: right"]163.4[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]174.8[/TD]
[TD="class: xl63, align: right"]180.0[/TD]
[TD="class: xl63, align: right"]172.4[/TD]
[TD="class: xl63, align: right"]167.5[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]174.6[/TD]
[TD="class: xl63, align: right"]183.4[/TD]
[TD="class: xl63, align: right"]173.6[/TD]
[TD="align: right"]176.8[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]175.4[/TD]
[TD="class: xl63, align: right"]183.2[/TD]
[TD="class: xl63, align: right"]172.8[/TD]
[TD="class: xl63, align: right"]166.3[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]183.7[/TD]
[TD="class: xl63, align: right"]176.5[/TD]
[TD="class: xl63, align: right"]171.5[/TD]
[TD="class: xl63, align: right"]166.6[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]183.6[/TD]
[TD="class: xl63, align: right"]177.1[/TD]
[TD="class: xl63, align: right"]14.2[/TD]
[TD="class: xl63, align: right"]165.4[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]184.8[/TD]
[TD="class: xl63, align: right"]177.5[/TD]
[TD="class: xl63, align: right"]179.1[/TD]
[TD="class: xl63, align: right"]167.1[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]174.9[/TD]
[TD="class: xl63, align: right"]180.0[/TD]
[TD="class: xl63, align: right"]177.5[/TD]
[TD="class: xl63, align: right"]168.8[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]175.9[/TD]
[TD="class: xl63, align: right"]182.1[/TD]
[TD="class: xl63, align: right"]179.6[/TD]
[TD="class: xl63, align: right"]165.2[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]176.8[/TD]
[TD="class: xl63, align: right"]184.3[/TD]
[TD="class: xl63, align: right"]181.3[/TD]
[TD="class: xl63, align: right"]175.6[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]183.7[/TD]
[TD="class: xl63, align: right"]175.4[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]180.2[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]184.8[/TD]
[TD="class: xl63, align: right"]177.5[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]183.2[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]184.9[/TD]
[TD="class: xl63, align: right"]180.0[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]163.4[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]174.8[/TD]
[TD="class: xl63, align: right"]180.0[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]165.3[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]175.6[/TD]
[TD="class: xl63, align: right"]179.7[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]168.6[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]175.9[/TD]
[TD="class: xl63, align: right"]179.8[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]168.4[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]184.6[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]170.2[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]183.8[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]173.5[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]184.9[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]173.2[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]176.3[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]180.5[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[cerfani]

Try putting all the data into 2 columns...

[TABLE="width: 122"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD="align: right"]12/17/2017[/TD]
[TD="align: right"]174.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/17/2017[/TD]
[TD="align: right"]174.8[/TD]
[/TR]
[TR]
[TD="align: right"]12/17/2017[/TD]
[TD="align: right"]175.2[/TD]
[/TR]
[TR]
[TD="align: right"]12/17/2017[/TD]
[TD="align: right"]184.3[/TD]
[/TR]
[TR]
[TD="align: right"]12/17/2017[/TD]
[TD="align: right"]184.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/17/2017[/TD]
[TD="align: right"]185.4[/TD]
[/TR]
[TR]
[TD="align: right"]12/17/2017[/TD]
[TD="align: right"]175.4[/TD]
[/TR]
[TR]
[TD="align: right"]12/17/2017[/TD]
[TD="align: right"]175.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/17/2017[/TD]
[TD="align: right"]175.8[/TD]
[/TR]
[TR]
[TD="align: right"]12/17/2017[/TD]
[TD="align: right"]181.8[/TD]
[/TR]
[TR]
[TD="align: right"]12/17/2017[/TD]
[TD="align: right"]183.7[/TD]
[/TR]
[TR]
[TD="align: right"]12/17/2017[/TD]
[TD="align: right"]183.9[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]175.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]177.4[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]177.9[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]180.3[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]183.5[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]179.8[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]175.4[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]177.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]180.1[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]178.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]182.1[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]183.4[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]182.1[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]183.4[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]183.2[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]180.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]182.7[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]183.9[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]174.8[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]174.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]175.4[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]183.7[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]183.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]184.8[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]174.9[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]175.9[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]176.8[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]183.7[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]184.8[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]184.9[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]174.8[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]175.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]175.9[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]184.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]183.8[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]184.9[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]173.2[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]176.3[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2017[/TD]
[TD="align: right"]180.5[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]181.9[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]182.3[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]183.4[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]174.2[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]173.4[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]175.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]173.8[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]174.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]174.7[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]177.5[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]182.1[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]183.2[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]183.7[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]184.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]184.9[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]175.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]174.3[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]175.2[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]180[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]183.4[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]183.2[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]176.5[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]177.1[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]177.5[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]180[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]182.1[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]184.3[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]175.4[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]177.5[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]180[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]180[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]179.7[/TD]
[/TR]
[TR]
[TD="align: right"]12/19/2017[/TD]
[TD="align: right"]179.8[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]174.5[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]172.1[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]165.3[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]175.4[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]177.5[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]180[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]177.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]182.1[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]183.2[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]168.5[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]165.3[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]167.2[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]170.2[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]172.9[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]172.8[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]169.4[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]168.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]168.2[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]172.4[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]173.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]172.8[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]171.5[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]14.2[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]179.1[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]177.5[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]179.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/20/2017[/TD]
[TD="align: right"]181.3[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]176.4[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]175.8[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]175.9[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]173.8[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]174.2[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]173.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]175.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]175.7[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]175.9[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]174.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]174.5[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]175.3[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]174.9[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]175.8[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]176.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]175.4[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]172.1[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]163.4[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]167.5[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]176.8[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]166.3[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]166.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]165.4[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]167.1[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]168.8[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]165.2[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]175.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]180.2[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]183.2[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]163.4[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]165.3[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]168.6[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]168.4[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]170.2[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2017[/TD]
[TD="align: right"]173.5[/TD]
[/TR]
</tbody>[/TABLE]

 

[adelk2202]

Thank you! I tried doing it that way at first and it didn't work either. I will try again because you were obviously able to get it to work. Thank you for responding!

 

[cerfani]

No problem. When I did it, I just highlighted the entire 2 column table then I selected a scatter chart under the Insert Ribbon. It should create it like how mine is then you need to click on the Value Axis and adjust the minimum value so you can read the data.

 

[adelk2202]

When I tried to put my data into two columns it formatted the x-axis weird and in the Format Axis Options there is nowhere for me to change the Axis type to Date axis. I'm sure I'm doing something wrong but I can't figure out what.