Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Hi Mark,
I do agree with your view. I have to try some other alternative.
Thanx
Manish
You can overlay a text object with image on the chart to possibly get the effect you need.
-Rob
Hi Rob,
Can you please tell me , how to acheive this ?
Thanks,
Manish
Are you trying to add another bar that shows the difference? How about using a reference line?
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.
Thanks John,
This is what, I want to do.
- Manish
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