Re: Charting in Excel to Powerpoint - Quality

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tim Williams (saxifrax_at_pacbell*dot*net)
Date: 11/20/04 

Date: Sat, 20 Nov 2004 15:12:50 -0800

Excel charts have an export method which will save it as gif or jpeg.
No need to bother with powerpoint.

Active***.ChartObjects(1).Chart.Export ThisWorkbook.Path &
"\temp.gif", "gif"

Tim.

"smcpoland" <smcpoland.1g0ujy@excelforum-nospam.com> wrote in message
news:smcpoland.1g0ujy@excelforum-nospam.com...
>
> Hi everyone,
>
> nice to see a dedicated forum for excel.
>
> Anyway, I have a excel *** that takes data from an Oracle
> database,
> does it's stuff and creates chart(s) - very nice it is too. However
> the
> Excel Charts are wasted as we need them on our web server for people
> to
> look at. The charts are created overnight....rather than
> dynamically -
> there is just no point in generating the same information all the
> time.
>
> Right - so I have a lovely excel chart which I want to use on the
> web -
> so I program excel to create a new Powerpoint presentation and copy
> the
> chart to the powerpoint slide and save it as (jpg, gif,png etc etc
> etc)
> BUT...
>
> the quality of the graph is terrible.....how do I get the quality of
> chart that I get in excel in powerpoint.....
>
> Or do I have to use something else like OWC?
>
> Thanks in advance
> regards
> Sean
>
>
> --
> smcpoland
> ------------------------------------------------------------------------
> smcpoland's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=16693
> View this thread:
> http://www.excelforum.com/showthread.php?threadid=318999
>

Quantcast