I can think of a couple of quick solutions --

One is you could put each chart in a seperate worksheet within your workbook
and you could click across the tabs to each one.

If your charts are always the same, or you don't mind soing some copying and
pasting when they do change --- you can copy them out of Excel and into a
word or powerpoint document and then page through them that way.

Eric

"Kim" wrote:

Hi everyone,

I have an Excel spreadsheet with a bunch of charts that I present to a
group of people each week.

Currently, I have all the charts on one sheet and just page down from
one to the next before giving my little speech on each.

My problem is that I constantly seem to be altering row heights and
such to make each chart fill the whole page so that paging down flicks
from one complete chart to the next.

My question is, is there a better way to present a sequence of charts
within Excel so clicking one button goes from one to the next? I don't
want to move the charts to powerpoint.

I did think that maybe detaching each chart from the workbook so that
they effectively float above the rows and don't change dimensions when
the row heights change, but I'm not sure how that might be done.

What are my options?

Thanks a lot guys for any help.

Kim