I have several Charts where I need Page Breaks to get a 6-page Print.

I set the Print Area, and then Insert - Page Break...it worked on a File.

Tried that in a second Excel File, but it forces all Charts onto a one-page
Print.

How do I get this to work?

TIA - Bob

Have you tried going into Page Break Preview and moving the page breaks to
where you want them?

Kathryn Groves


"Bob Barnes" wrote in message
...
I have several Charts where I need Page Breaks to get a 6-page Print.

I set the Print Area, and then Insert - Page Break...it worked on a File.

Tried that in a second Excel File, but it forces all Charts onto a
one-page
Print.

How do I get this to work?

TIA - Bob

Kate...One of the guys I work with knows Excel well.

He adjusted the Print to Page Size, and the Page Breaks I had then "Set"
themselves. I'm an Access Programmer and run Access-to-Excel automation,
but am learning OJT w/ Charts....I'm getting there.

Thank you - Bob

"Kate G." wrote:

Have you tried going into Page Break Preview and moving the page breaks to
where you want them?

Kathryn Groves


"Bob Barnes" wrote in message
...
I have several Charts where I need Page Breaks to get a 6-page Print.

I set the Print Area, and then Insert - Page Break...it worked on a File.

Tried that in a second Excel File, but it forces all Charts onto a
one-page
Print.

How do I get this to work?

TIA - Bob