Export a bar chart to excel

[#1]

I've been looking through the forum for an answer for this and I haven't been able to find a good one.

My question is very simple. I want to export a bar chart (image) from qlikview into excel by clicking on the export to excel button. Problem is, when I do this, it exports a table of the values used to create the bar chart and not the actual graph itself. Does anyone know how you can enable qlikview to do this?

[shumailh]

As far as my knowledge is concern, I never seen any simple way to this. May be there would be a macro to generate bar chart on excel.

Regards,
Shumail

[manishkumar75]

Hi,

There is no direct QlikView option which can be enabled to Export Graph into Excel. Alternatively you can achieve this by writing a macro . The macro is as below :-

Sub ExportGraph()
Dim vSheet
Set XLApp = CreateObject("Excel.Application")
XLApp.Visible = TRUE
Set XLDoc = XLApp.Workbooks.Add
vSheet = ""
vSheet = "Sheet1"
ActiveDocument.GetSheetObject("CH26").CopyBitmapToClipboard 'Copy the charts
XLDoc.Sheets(vSheet).Range("A" & 1).Select
XLDoc.Sheets(vSheet).Paste

Set XLDoc = Nothing
Set XLApp = Nothing


End Sub

Hope, it will work.

[sparur]

Hello, Manish.

Your macro will export chart as a bitmap (as a picture) but will not create a bar chart in Excel 😞

[manishkumar75]

It is true, that the macro will export chart as bitmap(as a picture) , but this what asked in the post.

Below is the problem statement :

My question is very simple. I want to export a bar chart (image) from qlikview into excel by clicking on the export to excel button. Problem is, when I do this, it exports a table of the values used to create the bar chart and not the actual graph itself. Does anyone know how you can enable qlikview to do this?

[#6]

Hi mainsh,

Yes your macro will export the bar chart but the macros are not running in the Qlikview 9.00 version in the Access point.

Since i am trying to do the same thing.Since macros are not working . I am left without solution 😞

Regards,XXX

[sparur]

Yeah, Manish.

sorry, I didn't understand about initial problem 🙂

[vardhancse]

Yes me also looking for similar requirement.

[vardhancse]

instead of macro we can get the image directly.

browser->In browser->Right click(on the required chart)->print->

Graph image will be opened in separate browser window->Image->right click->copy and paste in excel.

we can get as an image in excel

but looking for a solution to export direct graph instead of image