Creating one chart

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.

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.