Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I export a chart from Excel as a jpg or gif?
Does anyone know if it is possible to export an Excel generated chart/graph
as a .jpg or .gif into a webpage? |
#2
|
|||
|
|||
There is, but it involves another program (Paintshop Pro or something like it). Have Paintshop Pro open before you start Select the chart and with the SHIFT key depressed, go to EDIT and COPY PICTURE. You will be given the option of saving the picture as a BMP file - do this and paste the picture into Paintshop Pro. Save it as a *.jpg before moving this into your web page Jon -- Jon Quixley ------------------------------------------------------------------------ Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803 View this thread: http://www.excelforum.com/showthread...hreadid=467793 |
#3
|
|||
|
|||
You can select the chart. Copy it. Then do a paste special in programs like
Word. If your web design program doesn't have a paste special option, you can always paste it into word and then copy the pictures out. |
#4
|
|||
|
|||
Many thanks for your help. The thing is i need a non-techy person to be able
to be able to export the chart to a Content Management System so that they can publish it to a web page themselves, without having to use a web-design programme. Any ideas? "Blue Aardvark" wrote: You can select the chart. Copy it. Then do a paste special in programs like Word. If your web design program doesn't have a paste special option, you can always paste it into word and then copy the pictures out. |
#5
|
|||
|
|||
Andy Pope has a free add-in that you can use to export images or charts:
http://www.andypope.info/vba/gex.htm bongoman wrote: Does anyone know if it is possible to export an Excel generated chart/graph as a .jpg or .gif into a webpage? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#6
|
|||
|
|||
Does this help
Sub ExportChartJPG() ActiveChart.Export Filename:="C:\a\MyChart.jpg", _ FilterName:="jpeg" End Sub -- Don Guillett SalesAid Software "bongoman" wrote in message ... Does anyone know if it is possible to export an Excel generated chart/graph as a .jpg or .gif into a webpage? |
#7
|
|||
|
|||
John Walkenbach's Chart Tools also does this (http://j-walk.com).
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Debra Dalgleish wrote: Andy Pope has a free add-in that you can use to export images or charts: http://www.andypope.info/vba/gex.htm bongoman wrote: Does anyone know if it is possible to export an Excel generated chart/graph as a .jpg or .gif into a webpage? |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can I export a chart from Excel as a jpg or gif?
"bongoman" wrote: Does anyone know if it is possible to export an Excel generated chart/graph as a .jpg or .gif into a webpage? |
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can I export a chart from Excel as a jpg or gif?
You can use VBA code to export a chart.
ActiveChart.Export _ FileName:="current_sales.gif", FilterName:="GIF" Cheers Andy maryla wrote: "bongoman" wrote: Does anyone know if it is possible to export an Excel generated chart/graph as a .jpg or .gif into a webpage? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#10
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can I export a chart from Excel as a jpg or gif?
Sub ExportChartJPG() ActiveChart.Export Filename:="C:\a\MyChart.jpg", _ FilterName:="jpeg" End Sub -- Don Guillett SalesAid Software "maryla" wrote in message ... "bongoman" wrote: Does anyone know if it is possible to export an Excel generated chart/graph as a .jpg or .gif into a webpage? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export from Oracle into Excel, "Open" is not an option in XP | Excel Discussion (Misc queries) | |||
Activating a Chart object | Charts and Charting in Excel | |||
Updating Excel OLE chart data in PPT from Excel | Charts and Charting in Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Fan charts | Charts and Charting in Excel |