Combining

T

Tamsin

I want to create a chart for a hotel showing the "budget" for each month of
the year. Clustered with this I want to show the "actual" cash taken for the
months to date (October through to January).

Next to the remaining "budget" columns (Feb through to September) I want to
cluster a stacked bar where the top stack shows "forecast" cash bookings and
the bottom shows "actual" cash bookings.

So the first four months should have two single bars per month and the
remaining months should have a single bar clustered with a stacked bar.

Can anyone help or is there a simpler way to show this information?

many thanks

Tamsin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top