Excel 2003 SP2
WinXP Pro SP2

I have an Excel spreadsheet with about 4000 rows and 52-ish columns. The
top set of rows 1-13 are descriptive in nature. The general format of the
spreadsheet is
A: Day of week (Monday-Friday etc)
B: Actual date
C-E: Captured data
F: Useable Calculated Data (formula #1)
G-I: Calculated Data
J: Useable Calculated Data (formula #2)
K-L: Calculated data
M: Useable Calculated Data (formula #3)
O-Q: Calculated Data
R: Useable calculated data (formula #4)
etc...
What I'd like to do is to see a graph whereby the Y-axis is related to the
Useable Calculated Data and the X-axis is the Actual Date (Column B). Some
of the useable calculated data varies from 0-1 (something akin to
probabilities) and some of the Useable Calculated Data varies from 0-5 (a
smoothing calculation). So a dual Y-axis representation with colors assigned
to the various Useable Calculated Data columns would be very helpful here.
That is, the left Y-axis could be 0-1 based and the right Y-axis could be 0-5
based. If this isn't such an easy or good idea, then I'll deal with it. I'm
attempting to see the data displayed in a flowing 'sine-wave' format and to
determine if the peaks and valleys coincide in the Useable Calculated Data
columns.
TIA!!!