Help!! Line Graph on 2 Axis

[CJordani]

Hello all!

I have to create a graph with two variables on the left Y axis and one on the right Y axis while showing the year on the X axis. However, whenever I try to create a graph it shows the year as a line on the graph and it just has 1 2 3 4 5 6 7... etc, on the X axis.

I've done this a few years ago, I just can't remember how to insert the year on the X axis so it won't show up on the line graph.

Here's how I am selecting my data before I select the graph:
YEAR - 2004 2003 2002 2001 2000 1999 1998
CBR - 11 12 13 14 15 16 17
CDR - 6 7 8 9 10 11 12
POP - 213 231 232 232 231 213 287

-----

Is that the right way of putting my data on the excel grid before I hightlight it and selecting my graph?

Thank you and any help would be greatly appreciated!!
-CJordani

 

[CJordani]

No help?

 

[jdee]

Hi:
I am attaching data layout below. Just choose the chart wizard, then choose custom types, choose lines on 2 axes, choose next, add your titles, etc. and you should have what you are asking for. I have tried it using XP and office 2000 and it works.

Book1
	A	B	C	D
1		2004	2005	2005
2	cbr	11	12	13
3	cdr	6	7	8
4	pop	213	214	215
5
6	YearonXAxis
7	cbrandcdron1stYaxis
8	popon2ndyaxis
Sheet1

 

[CJordani]

Wow, thank you very much! I appreciate it!
-CJordani

 

[jdee]

You are welcome, glad I could be of help, especially since so many others on this board have helped me. J.Dee