On Apr 7, 12:08 pm, Herbert Seidenberg <herbds7-ms...@yahoo.com>
wrote:

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.