Graphing Problem

  • Thread starter Thread starter Chris Guimbellot
  • Start date Start date
C

Chris Guimbellot

Hello,

I know this may defy logic, but here goes anyway. In Excel 2000, is it
possible to graph two related, but not directly related sets of numbers on
the same graph? I'll explain. I have included some numbers below. The two
sets are reservations and revenue. If you were to create a line graph of the
reservations set and then create another graph of the revenue set, the lines
correlate with minor, though natural, differences. If you were to create one
graph with both sets, the reservations line would barely leave the X axis
(due to the fact that each reservation is about $100).

However, if you were to superimpose the lines onto the same graph
(disregarding the values of the Y axis), you could see the correlation of
the two sets.

My question is is it possible to superimpose the lines onto the same graph
without regard for the scale of the Y axis?

I have included the sample data that should illustrate the point below. I
appreciate any help.

Thanks,

Chris

Reservations Revenue
January 850 $96,666.80
February 1034 $116,055.85
March 1417 $156,511.57
April 1103 $101,853.68
May 1482 $140,459.97
June 1791 $178,205.12
July 1786 $163,519.18
August 1576 $142,821.40
September 1334 $106,705.09
October 1138 $89,414.88
November 727 $52,541.69
December 450 $35,572.07
 
JR,

Thanks. After more research, I discovered how to do the chart with the two
Y-axes. The only ones I see that you can use are Line - Column on 2 Axes and
Lines on 2 Axes. I found these by clicking on custom types under chart type.
Are these the only ones I can use? I would think there can be more.

Also, I didn't think about dividing the reservations by 10,000. That's a
good idea.

Thanks,

Chris
 
Chris -
Are these the only ones I can use? I would think there can be more.
Click to expand...

You have much more power at your fingertips. Make a line chart with
both sets of data, then double click one of the series, and on the Axis
tab of the dialog that pops up, click Secondary.

Another way to see a correlation would be to select the Reservations and
Revenue columns (omit the date), and build an XY Scatter chart.

- Jon
 
Back
Top