SiO2	48.6	50.68	63.81	59.85	53.5	69.36	74.12	55.92
FeO	10.31	9.27	4.05	5.39	8.31	2.32	1.26	7.32
MgO	6.73	6.12	2.28	3.58	5.42	1.14	0.16	4.04
CaO	10.65	9.67	4.87	5.95	7.63	3.07	1.23	6.77
Na2O	2.47	2.7	3.72	3.65	3.18	3.92	4.08	3.49
K2O	0.25	0.48	1.96	1.28	0.73	3.02	4.47	0.97


Paste the above data into an Excel spread sheet.  Press the "graph
wizard" button.  Select "XY (Scatter Plot)" and the "Finish".  Adjust
x-axis domain to 45-80%.

From there, how do I:

1.  Connect the data points with colored lines that go only left to
right.

2.  Draw vertical lines on the graph at (x= 52, 57, 63, 70) and label
them?

Note: Part 1 seems easy but it's not because the "trend lines" don't go
through the points and aren't colored -- and the "format data series"
draws lines only in the order of the data column, not in the natural
order (left to right).  I need lines that go through the data points
from left to right and are colored.

---

Clarification of Question by tanukitzu-ga on 25 Jan 2003 11:17 PST

The tab spacing in the data was replaced with spaces in the final post.

How can I put tabs in the text box and have them remain in the final post?

Meanwhile here is the data column by column.

SiO2
FeO
MgO
CaO
Na2O
K2O


48.6
10.31
6.73
10.65
2.47
0.25


50.68
9.27
6.12
9.67
2.7
0.48


63.81
4.05
2.28
4.87
3.72
1.96


59.85
5.39
3.58
5.95
3.65
1.28


53.5
8.31
5.42
7.63
3.18
0.73


69.36
2.32
1.14
3.07
3.92
3.02


74.12
1.26
0.16
1.23
4.08
4.47


55.92
7.32
4.04
6.77
3.49
0.97