topic Export a bar chart to excel in QlikView

Export a bar chart to excel

Tue, 29 Jun 2010 00:51:18 GMT

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?

Export a bar chart to excel

shumailh — Wed, 21 Jul 2010 07:54:32 GMT

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

Export a bar chart to excel

manishkumar75 — Wed, 21 Jul 2010 12:55:24 GMT

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.

Export a bar chart to excel

sparur — Wed, 21 Jul 2010 13:20:10 GMT

Hello, Manish.

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

Export a bar chart to excel

manishkumar75 — Wed, 21 Jul 2010 13:33:49 GMT

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?

Export a bar chart to excel

Wed, 21 Jul 2010 13:38:22 GMT

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

Export a bar chart to excel

sparur — Wed, 21 Jul 2010 13:48:08 GMT

Yeah, Manish.

sorry, I didn't understand about initial problem 🙂

Re: Export a bar chart to excel

vardhancse — Tue, 23 Jun 2015 08:40:17 GMT

Yes me also looking for similar requirement.

Re: Export a bar chart to excel

vardhancse — Tue, 23 Jun 2015 08:55:16 GMT

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