Hi everyone,

nice to see a dedicated forum for excel.

Anyway, I have a excel sheet that takes data from an Oracle database
does it's stuff and creates chart(s) - very nice it is too. However th
Excel Charts are wasted as we need them on our web server for people t
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 th
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 o
chart that I get in excel in powerpoint.....

Or do I have to use something else like OWC?

Thanks in advance
regards
Sea

--
smcpolan
-----------------------------------------------------------------------
smcpoland's Profile: http://www.excelforum.com/member.php...fo&userid=1669
View this thread: http://www.excelforum.com/showthread.php?threadid=31899

Hi Sean

you said "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" .....

just wondering why you don't just save the chart sheet as a web page (file /
save as web page) - which, BTW does generate a gif from the chart and then
you wouldn't have to deal with PowerPoint.

is this an option?

Cheers
JulieD




"smcpoland" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Hi everyone,
>
> nice to see a dedicated forum for excel.
>
> Anyway, I have a excel sheet 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...o&userid=16693
> View this thread: http://www.excelforum.com/showthread...hreadid=318999
>

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

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

Tim.



"smcpoland" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Hi everyone,
>
> nice to see a dedicated forum for excel.
>
> Anyway, I have a excel sheet 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...o&userid=16693
> View this thread:
> http://www.excelforum.com/showthread...hreadid=318999
>