Excel 2013 Chart

[kuzniak]

I am trying to create a chart, I can see it in my mind, but I'm sure I don't know all the correct jargon to describe it. The x-axis will be analytes (F, Cl, Br, etc) and the y-axis will be a concentration value. I can do this with a line chart. The problem I'm having is that each series will have multiple data points per analyte. So Series 1 (ex, tap water) will have 6+ data points for F, Cl, Br, etc; Series 2 (ex, distilled water) will have 6+ data points for F, Cl, Br, etc...
Is this possible to do?

 

[RickXL]

Re: Excel 2013 Chart Help

Hi and welcome to the MrExcel Message Board,

I sounds as if you need a Line Chart with multiple lines.

So, put the "analytes" in column A then add a column for every series you need to chart.

If that is not what you want then I will need a bit more of a description.


Regards,

 

[kuzniak]

Re: Excel 2013 Chart Help

Any line chart I make can only have one data point per series per analyte. How do I do multiple data points?

 

[RoryA]

Re: Excel 2013 Chart Help

Perhaps you want an XY scatter.

 

[kuzniak]

Re: Excel 2013 Chart Help

XY scatter doesn't allow text in the X axis.

 

[RoryA]

Re: Excel 2013 Chart Help

No, but you can mock them up using a dummy series with data labels.

 

[RickXL]

Re: Excel 2013 Chart Help

An example chart would be nice.

If you Google "analytes", say, and select images is there a chart in there that you would like to replicate? If so, could you post a link so that we can see what is required.

Thanks,

 

[kuzniak]

Re: Excel 2013 Chart Help

This is what i'm trying to do.
https://imgur.com/3zdABuG

 

[RoryA]

Re: Excel 2013 Chart Help

If it's always the same categories, you could simply use textboxes for those labels.

 

[thisoldman]

Re: Excel 2013 Chart Help

Try organizing your data like this:

Book1
	A	B	C	D	E	F	G	H	I	J	K
1			Pond			Lake			Sea
2			A	B	C	A	B	C	A	B	C
3		Ca	38	36	27	31	28	18	2	1	3
4		Mg	6	8	10	7	7	3	4	1	7
5		Na	17	51	10	18	21	8	4	1	10
6
7			Ca	Mg	Na
8	Pond	A	38	6	17
9		B	36	8	51
10		C	27	10	10
11	Lake	A	31	7	18
12		B	28	7	21
13		C	18	3	8
14	Sea	A	2	4	4
15		B	1	1	1
16		C	3	7	10
Sheet1

Either the top or the bottom arrangement will work.

Select the data block and insert a line chart. Select the chart, bring up the right click menu and choose "Select Data...". Click the button that says "Switch Row/Column".

Now you have to do your formatting–removing lines, changing symbols, correcting the legend, etc.