Excel charts on a webpage

G

Guillermo

I need to place some Excel charts on my webpage.
Can I do it without uploading the whole xls file?.
What's the best way or format to do it, without losing
color or definition?. Thanks. Guillermo.
 
C

Cesar Zapata

Take a screenshot then open MS paint or photoshop then paste it and save
it and upload it.
 
D

Dave Peterson

A couple of more options.

Take a look at VBA's help for Export. There's sample code to save a chart as a
..gif.

Here's the snippet of code that they used:

Worksheets("Sheet1").ChartObjects(1) _
..Chart.Export _
FileName:="current_sales.gif", FilterName:="GIF"



Another option, depending on your version of excel.

I use xl2002.

When I saved a workbook as "Web Page (*.htm; *.html)", I got a subfolder that
contained a bunch of files. One of these files was image001.gif and it
contained my test chart picture.
 
J

Jon Peltier

Guillermo -

Today I answered a similar question in the charting group, and I
provided a small macro that enabled the user to set the height and width
of the chart in pixels.

Also, John Walkenbach's Chart Tools addin (free at http://j-walk.com)
has a chart export feature.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/Excel/Charts/
_______
 
N

Nikki

There is a way to stop the subfolders from being created, and it would just create the file in whatever path you have told it to save the html to. Under Tools/Options/General/Web Options/Files - unselect the "organize supporting files in a folder" option. This will not create the subfolder, will create 3 files instead. The GIF file, the HTML file, and an XML file.
 
Top