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!

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

<tbody>
</tbody>

 

[cerfani]

Try putting all the data into 2 columns...

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

<tbody>
</tbody>

 

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