Stacked Bar Chart

[manishkumar75]

Is it possible to put dynamic Image in the Chart (like Text) ? Actually, I need to show the margin of revenue in stacked bar chart comparing with previous year.

[#2]

I don't think that is possible, like the the name tells "Text in Chart". I never noticed an option to define this text as image. Maybe you can use an icon/symbol in the chart that belongs to a fonttype to achieve the same result.

[manishkumar75]

Hi Mark,

I do agree with your view. I have to try some other alternative.

Thanx

Manish

[rwunderlich]

You can overlay a text object with image on the chart to possibly get the effect you need.

-Rob

[manishkumar75]

Hi Rob,

Can you please tell me , how to acheive this ?

Thanks,

Manish

[rwunderlich]

Are you trying to add another bar that shows the difference? How about using a reference line?

[manishkumar75]

Hi Rob,

I want to show the difference as depicted in the attached image.

Thanks

-Manish

[johnw · Accepted solution]

See the attached example. There are three text boxes overlayed on the chart. And UP box, a DOWN box, and the amount it is up or down. The UP box is only displayed if it is up or steady. The DOWN box is only displayed if it is down. To overlay images, simply replace the text in the UP and DOWN boxes with images on the General tab of the text box.

[manishkumar75]

Thanks John,

This is what, I want to do.

- Manish

[manishkumar75]

Hi John,

I am also exporting the Chart Image to Excel using the following Macro :

Sub ExportImg

set XLApp = CreateObject("Excel.Application")
XLApp.Visible = True
set XLDoc = XLApp.Workbooks.Add
ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard
XLApp.Worksheets(1).Range("A1").Select()
XLApp.Worksheets(1).PasteSpecial

End Sub

Now , when three text boxes are added to chart, how can I Export these text boxes alongwith the chart.

Thanks,

Manish