Importing images from the web to Excel

Sylv1

New Member
Joined
Sep 20, 2011
Messages
1
Hi all,
I am new to this board but I read so many threads that I feel at home already! ;)
Here is my problem : I am trying to make a financial report in excel. I already have queries importing data from the web like stock quotes and such, and I would like to add graphics to my worksheet.

The easiest way that I thought of is to import graphics already available on the web, just like this one for example :

http://charts2.euronext.com/charts/...INFO=Grid,HighLowMark&HEIGHT=215&PERIOD=1Y&DI

I am able to import this image with Insert>Image and it looks great, but I would like it to update itself, at least when I open my workbook, at best when I click the image.
I tired making a webquery with this particular address but it does not work.

Any idea on how to do that?

Thank you

Sylvain
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
I too need to import graphics from web into a spreadsheet.
I'm importing data from web, selected the table in the website that I want to import. All the data comes in just fine.

First issue: The website shows graphics (not graphs) but they don't come in to the spreadsheet. There are only 7 different ones so if there is a way to tell excel to show this graphic if cell A1=70 and that graphic if A1=30, then I could certainly use that.

Second issue: when I update the data, it adds a column after the data (I suspect this may be a spacer for the graphic in the website).

http://beta.weather.com/weather/print/USOR0275 is an example of the table I'm pulling from the web.

Any help?
 
Upvote 0

Forum statistics

Threads
1,224,522
Messages
6,179,297
Members
452,903
Latest member
Knuddeluff

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top