custom chart and image control

  • Thread starter Thread starter rvExcelTip
  • Start date Start date
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)
 
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
 
Back
Top