I am trying to make a REE diagram and a primordial mantle normalization diagram

Question

I am trying to make a REE diagram and a primordial mantle normalization diagram on excel but cannot figure out to make it.

I am making a multi data series where i the x-axis to be trace element symbols and then on the y-axis the ppm of those elements.

example:

Rb- values- 121,128,116,131

Sr- values- 200,222,200,210

Nd- 300,310,320,330

there will be a whole list of trace elements going across the x-axis, the values for each series must be connected. So rb121 sr 200 and Nd 300 would all be connected with a line as one data series.

Explanation / Answer

Take a look at this:

https://docs.google.com/file/d/0B_OhyWb0ohpBbnNPV1I4ZTcxM28/edit?usp=sharing

Basically, make each element data in a row, and give all columns a heading (1,2,3,4....)

Then simply,select all, and create a chart.

It may happen that the axes are switched (elements are linked, not the series). If so, go to the design tab (excel 2010+), when the chart is selected, and and use "Switch Row/Column" in the Data section (3rd option in the ribbon)

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.