excel charts and powerpoint

[Sara Tanner]

What is the easiest/best way to get an excel chart into a 2003 document?

I don't want the thin gray lines that seem to come when I cut and paste and
when I do a screen grab it is on a white background. I would eventually
just like it to be white text with the background showing.

Thanks

Sara

 

[Brian Reilly, MVP]

Sara,
Steve's information on links is quite correct, but can lead to
problems later if you move files around or to another hard drive.
So I, for the most part,gave up linking years ago.

I now copy the chart and/or worksheet to another workbook so you only
have one or two sheets in this new workbook. From the menu it is Edit
+ Move or Copy Sheet + Check the box Create a Copy + Change the To
book dropdown to New book and click OK. If you are using custom color
palettes like I frequently do, You will then want to copy the color
palette from the original workbook, Tools + Options, click the Color
tab, and change the dropdown for Copy Colors From to the original
workbook. Then you can use copy and paste and throw away the temporary
workbook (after pasting).

That way you only embed a single sheet or two into the PPT
presentation.

Brian Reilly, MVP

 

[Brian Reilly, MVP]

Steve,
One of these days, I'll generizie the VBA to do this. It's actually
not all that long but always has extra stuff in it due to the specific
needs of the project.
Brian Reilly, MVP