custom chart and image control

R

rvExcelTip

I created a chart type that contained an image control (company logo)
and a textbox. I saved that chart as a custom chart type.
But when I selected that custom chart through the chart wizard in
another workbook, the image and textbox controls didn't appear.

I even edited with copy and paste those controls directly into
xlusrgal.xls where custom chart types are held, but they refused to
show up in my charts.

Can it be done? and how?

PS: I posted this question on the general forum earlier (I don't yet
have the reflex to look at other forums. sorry)
 
J

Jon Peltier

Apparently these objects that are pasted into a chart are not considered
part of the chart's format (although the text of a title is, go figure).

If you use a picture as a custom fill for a series, plot area, or chart
area, it will become part of the chart's formatting. So perhaps you
could put the logo into the corner of a larger blank rectangular image,
and use that image as the chart area or plot area fill.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top