How to put a picture on my charts

rdionne · May 22nd, 2002, 04:44 PM

I would like to put our company's logo on my embedded charts. I don't want to carry an extra seperate file around, so I'd rather not use Loadpicture(). I placed my logo picture on a hidden worksheet so it would be contained within my workbook. How can I take the picture and place it onto the chart? Do I have to use the clipboard? Is there an OLEshape method that I can use? I know how to reference the picture in the workbook, I just don't know how to use that reference with an object on the chart.

Ivan F Moala · May 22nd, 2002, 06:28 PM

Quote:

On 2002-05-22 15:44, rdionne wrote:
I would like to put our company's logo on my embedded charts. I don't want to carry an extra seperate file around, so I'd rather not use Loadpicture(). I placed my logo picture on a hidden worksheet so it would be contained within my workbook. How can I take the picture and place it onto the chart? Do I have to use the clipboard? Is there an OLEshape method that I can use? I know how to reference the picture in the workbook, I just don't know how to use that reference with an object on the chart.

There no need to do that...just insert the picture from the file path ie. select plot area > right click > Format Plot Area > Fill effects > Picture > select picture > select file. Your done. Pictue is not inserted as a link so the file is tranferable between machines without loss of picture.

rdionne · May 23rd, 2002, 09:25 AM

I'm creating my charts with VBA, so all the charts are created on-the-fly. Maybe I can make a dummy chart to hold the picture, or maybe work with a resource or DLL file. I just don't want to have to have a line loading the picture from a static path.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 04:44 PM	#1
rdionne New Member Join Date: Feb 2002 Location: Texas Instruments Posts: 47	I would like to put our company's logo on my embedded charts. I don't want to carry an extra seperate file around, so I'd rather not use Loadpicture(). I placed my logo picture on a hidden worksheet so it would be contained within my workbook. How can I take the picture and place it onto the chart? Do I have to use the clipboard? Is there an OLEshape method that I can use? I know how to reference the picture in the workbook, I just don't know how to use that reference with an object on the chart.

May 23rd, 2002, 09:25 AM	#3
rdionne New Member Join Date: Feb 2002 Location: Texas Instruments Posts: 47	I'm creating my charts with VBA, so all the charts are created on-the-fly. Maybe I can make a dummy chart to hold the picture, or maybe work with a resource or DLL file. I just don't want to have to have a line loading the picture from a static path.