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" wrote in message
...

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" wrote in message
...

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