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
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Desper84AnAnswer" wrote:

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.