I can't get Excel to use my data for X axis labels

[JenniferMurphy]

I have some data that I want to plot with X axis labels that are the combination of two sets of data. Here's the mini sheet.

Book1
	B	C	D	E	F	G	H	I
4	Dates				Average mg/dL
5	Start	End	Days	X Axis	AM	PM	Insulin	Victoza
6	6/10/20	8/31/20	82	8/31/20 (82)	153	216	56
7	8/11/20	10/27/20	77	10/27/20 (77)	153	207	45	1.12
8	10/12/20	2/02/21	113	2/02/21 (113)	163	207	45	1.72
9	1/20/21	2/20/21	31	2/20/21 (31)	159	213	45	1.80
10	2/20/21	3/07/21	15	3/07/21 (15)	159	228	46	1.80
Summary Chart

Cell Formulas
Range	Formula
D6:D10	D6	=C6-B6
E6:E10	E6	=TEXT(C6,"m/dd/yy") & " (" & D6 & ")"

I want the labels on the X axis to be those in E6:E10, which are the result of combining C6:C10 and D6:D10.

If I don't select anything for the X axis, I get a nice chart with counting numbers on the X axis. This is the chart I want, but with the values in E6:E10 as the labels in the X axis.

If I select C6:C10 for the X values, Excel correctly interprets the X values as dates and scales the axis accordingly. I want the X values to be uniformly spaced.

If I select E6:E10 for the X axis, I get a correct chart, but somehow Excel chose dates from 1/00/2000.

How can I get a chart line this one, but with the actual values in E6:E10 as X axis labels.

Thanks

 

[Tetra201]

Try selecting the 'Line with Markers' chart type.

 

[JenniferMurphy]

Try selecting the 'Line with Markers' chart type.

Very good, thank you.

I using a scatter chart with markers. I see now that it shoiws the relationship between 2 values, whereas the line chart only shows one set of values.