Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Pastimes : Computer Learning -- Ignore unavailable to you. Want to Upgrade?

To: GROUND ZERO™ who wrote (49863)	3/5/2006 10:41:18 AM
From: Gottfried	Read Replies (1) \| Respond to of 110630

GZ, I use Lotus 1-2-3 for a spread sheet and it has the feature you want. I can set up a second Y-axis for the 2nd variable. Maybe Excel has that, too? Here's some Excel help excelforum.com

To: GROUND ZERO™ who wrote (49863)	3/5/2006 2:45:00 PM
From: Kayaker	Read Replies (1) \| Respond to of 110630

It's called a "secondary axis" in Excel. This from Excel 2000 Help File in a section titled "Combination charts for showing mixed data" Secondary axis -- When the range of values for different data series varies widely, or when you have mixed types of data, you can plot one or more data series on a secondary value (y) axis. The scale of the secondary axis reflects the values for the associated series. The chart in the example above shows the number of homes sold on the left y-axis and the average price on the right y-axis.