HELP! Chart problem...can't figure it out.

[dotrain4u]

Hello,

I have a data sheet with 7 dates down column A, 7 values for VALUE down column B, and 7 values for TANGIBLE VALUE down column C. They are all related and show a trend downward during the course of 3 years. I have created a line chart that shows this. Now I have 7 figures down column D that show that as value dropped down, they lowered their investment. I need to add column D as a totally separate series, which isn't related to the net worth, but is related to the exact same dates. It needs to show that as the value dropped, so did the investment.

Statement Date Value Tangible Value Investment
May 30, 2005 $133,818.00 $78,773.00 $75,000,000.00
July 30, 2005 $115,323.00 $57,525.00 $90,000,000.00
December 30, 2005$158,527.00 $107,416.00 $75,000,000.00
April 30, 2006 $101,175.00 $53,232.00 $90,000,000.00
August 30, 2006 $85,042.00 $37,227.00 $90,000,000.00
February 2, 2007 $53,548.00 $5,898.00 $50,000,000.00
May 3, 2007 $4,594 -$42,959.00 $50,000,000.00

Can anyone help me!

 

[Robert Mika]

You can add your investement line to secondary axis:

Is it that what you after?

 

[dotrain4u]

Yes! That looks just like what we had in mind. How can I recreate that?

Thanks!

 

[Robert Mika]

Just add your Investment data into secondary Axis.
Add your Investemd data into Chart in Normal way then
Right Click on the Investemt Axis -->Format Data Series-->Series Option-->Secondary Axis