Plotting 3 points per data set in lollipop-type chart

[charllottesu]

Hi,

I am wanting to plot a graph where I have multiple data points per category of data. For some context, I have done some analysis on different samples and now have up to 3 data points for each sample and I am wanting to present them in a lollipop chart-type way (see image). I'm wondering if this is possible to plot in excel, and if not, what is the easiest way to plot data in this way?

It would also be helpful if I could have 2 of these 'lines' of 3 data points (e.g. different colours) for each sample to present different values I'm extracting from the data of each.

Thanks,
Charllotte

 

[NateSC]

There may be a template for this type of chart somewhere, but I would likely just make it a Scatter Chart with Straight Lines and Markers. For each Sequence of data, repeat the X value for each Y. Change the marker to a circle and make the size much larger than normal (my chart has them at size 10). Then for the horizontal axis, I changed the major and minor Units to 1.0 and made the Bounds-Maximum 2.9 so the label for 3 would not show. It was the easiest way I could think of to achieve the effect you are desiring.

Book1
	A	B	C	D
1	Sequence	1	Sequence	2
2	X	Y	X	Y
3	1	8	2	6
4	1	10	2	11
5	1	12	2	15
Sheet1

 

[charllottesu]

There may be a template for this type of chart somewhere, but I would likely just make it a Scatter Chart with Straight Lines and Markers. For each Sequence of data, repeat the X value for each Y. Change the marker to a circle and make the size much larger than normal (my chart has them at size 10). Then for the horizontal axis, I changed the major and minor Units to 1.0 and made the Bounds-Maximum 2.9 so the label for 3 would not show. It was the easiest way I could think of to achieve the effect you are desiring.

Book1
	A	B	C	D
1	Sequence	1	Sequence	2
2	X	Y	X	Y
3	1	8	2	6
4	1	10	2	11
5	1	12	2	15
Sheet1

View attachment 105270

Thank you for your reply! I have plotted similar graphs to the type are describing however my issue is that the X-axis “values” would actually be sample names rather than numbers so for example it would be “human 1 sample” and that sample would have 3 data points. I’m not aware of any way to plot that type of graph with “categories” on the x-axis.