Automatically crop an excel chart 2

[greggb]

Is it possible to automatically (macros) crop an excel chart? The white space around the edges of the chart are giving me problems after I append it to a VPF general field and then try to use them in the report. With multiple graphs they end up (what appears to be) too far apart.

Any suggestions?

 

[SkipVought]

Hi,

Have you tried expanding the Plot Area within the Chart Area?

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[greggb]

Skip,

How do you do that? When I tried to drag the (pie) chart to spread it out it exploded.

Thanks.

 

[SkipVought]

1. select in the chart JUST INSIDE the outer perimiter. Notice that the NAME BOX contains Chart Area

2. select in the square (immaginary or not) surrounding the pie in any of the corners of the square. Notice that the NAME BOX contains Plot Area

You can drag any one of the corners of the Plot Area to increase or decrease the size if the Plot Area.

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[greggb]

That worked. Thanks! Probably the easiest star you've earned!

 

[SkipVought]

Glad it worked. After all...

you wouldn't want your chart to be...

a crappie!

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[01Patrik]

Skip, I actually believe that to be some of worst humor I've heard in a while. Deserves a star.

// Patrik
______________________________

To the optimist, the glass is half full. To the pessimist, the glass is half empty. To the IT Professional, the glass is twice as big as it needs to be.