Creating one chart

[Desper84AnAnswer]

How do I create a chart which shows both a total number of bookings & the
total revenue matched against months of the year. e.g:

Months Total Bookings Total Revenue
Jan 39 $10.00
Feb 20 $5.00
Mar 15 $21.00

The list above is on a separate worksheet & I want to create a chart on a
different worksheet but in the same workbook.

 

[Luke M]

You could either do a combination chart (bars and lines?) with one of the
series on a secondary axis, or you cuold try to create a panel chart:

http://peltiertech.com/Excel/Charts/StackedCharts.html

 

[Jon Peltier]

The values aren't different enough to require dual axes. A plain old
line chart would work fine.

- Jon