Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

manishkumar75
Contributor II

Stacked Bar Chart

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.

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Stacked Bar Chart

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.

13 Replies
Not applicable

Stacked Bar Chart

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
Contributor II

Stacked Bar Chart

Hi Mark,

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

Thanx

Manish

Stacked Bar Chart

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

-Rob

manishkumar75
Contributor II

Stacked Bar Chart

Hi Rob,

Can you please tell me , how to acheive this ?

Thanks,

Manish

Stacked Bar Chart

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

manishkumar75
Contributor II

Stacked Bar Chart

Hi Rob,

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

Thanks

-Manish

MVP
MVP

Stacked Bar Chart

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
Contributor II

Stacked Bar Chart

Thanks John,

This is what, I want to do.

- Manish

manishkumar75
Contributor II

Stacked Bar Chart

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

Community Browser