Graphing Multiple Data Points

M

Monty

What would be the best way to graph this and how? I've been trying to
do a line graph because this is how we wanted it displayed but I'm
having a hard time trying to figure this out.

Sample Data

Monday Tuesday Wednesday
Thursday Friday Saturday Sunday
Week 1 Occupancy 56% 65% 54%
75% 80% 82% 54%
ADR $80.00 $85.00 $84.50
$86.50 $89.50 $84.26 $86.54
Week 2 Occupancy
ADR
Week 3 Occupany
ADR
Week 4 Occupancy
ADR

This would be for 4 weeks only. I'm really struggling here. Please
help.

- Monty
 
M

Monty

Use Pivot Table.
Graphs are automatic.http://www.freefilehosting.net/download/3f0kj
Click to expand...

I've been able to do the same thing without the pivot table but I see
where you make the pivot table easeir to make for graphing. This is
my fault though because I didn't explain enough. I actually want One
Graph. I can make two but I want one. For example I want the line
graphs to be on one line but have control over the values displayed.
So on the Y axis I want the percentage displayed much like you've done
for Chart Occupancy and the Days on the X axis are excactly where they
should be.

For the ADR where this is Dollar Figures. I just want the line graph
only to move over to the save Occupancy Chart. The data points for
each day would still show the dollar figures and the X axis would be
the same but the Y axis would show nothing and leave it with
percentages.

http://www.freefilehosting.net/download/3f0l0

I just drew in the ADR $ amounts but this is how I want it to look.
 

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

Similar Threads

Group dates onto a chart 3
Day and Date Autofill 7
Rotating Work Schedule 7
conditional format of adjacent cell with different range and crite 1
WEEKDAY 7
If Command 1
multiple critera formula 3
Week and days query 8

Top