Sharing chart on two pages
 

Hello,

I have a worksheet where I put some datas and then under this datas is a
chart. Place taken by this data isn't static - once there is more datas and
the other time there is more datas. I have problem with this chart, because
sometimes chart is shared between two pages on printing. Is there a
possibility to use something like property "keep together" in crystal
reports where object is printed whole on one page (if there is no enough
place it's started pritnting on next page)? Maybe somebody knows how to do
it in macro if there is no appropriote property

--
Best Greetings
Darek

Sharing chart on two pages
 

Hi

easiest is to do this "manually"

In the print preview, you can see how the chart relates to the page ends.
Move it then to fit.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"DarekP" wrote:

Hello,

I have a worksheet where I put some datas and then under this datas is a
chart. Place taken by this data isn't static - once there is more datas and
the other time there is more datas. I have problem with this chart, because
sometimes chart is shared between two pages on printing. Is there a
possibility to use something like property "keep together" in crystal
reports where object is printed whole on one page (if there is no enough
place it's started pritnting on next page)? Maybe somebody knows how to do
it in macro if there is no appropriote property

--
Best Greetings
Darek