anyone know excel

[sammy004]

Hey guys I'm tring to make a chart and i'm tring to make a secondary axis. Can anyone tell me how I can make a seconary axis. I have 3 catagories
Year Price Sold and I want year on the bottom and price on the left side and sold on the right but I don't know how to do it. I select all the 3 catagories but I only get 1 x and 1 y axis when I want 2 y axis. If anyone know what i'm talking about can you please help me out thanks.

[Goosey]

I am taking a Word Processing course right now and we are doing charts and stuff in excel...I should be able to figure it out for ya once I get to school...give me a hour and a half:)

[Goosey]

OK, I got it...what you do is...you do the chart how you would normally do it...make it so all three data series are in the chart...then you chose the line or bar or whatever that you want to be on the secondary axis and right click it....click format data series....then the Tab "Axis"...then you will see a little box that says "Plot series on"...chose secondary axis...click OK and there you go......

-Rob

[sammy004]

Hey thanks a lot man Ireally appreciate your help.
Thanks
Sammy

[sammy004]

hey guys I just bought this PSP and its awsome