Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exporting Charts to Excel

Hi guys,

is there any possibility to export charts to Excel so that it is showing the chart itself, not the values?

Thanks,
Lina

5 Replies
markodonovan
Specialist
Specialist

Hi Lina,

The simple way is to right click on the chart -> copy to clipboard -> then select image or object.  Then paste it into an excel document. 

Thanks

Mark

http://www.techstuffybooks.com

its_anandrjs

In place of exporting to excel print it as PDF and then save it as Pdf reports. Also you can use the reports wizard if want to print any chart as report.

Regards,

Anand

m_woolf
Master II
Master II

This can be done by a macro if using the IE plugin.

Search the community for details.

prashantbaste
Partner - Creator II
Partner - Creator II

Hi Lina

I know its too late to reply on this post, but might be helpful for others -

Try below macro -

Sub ExportToExcel

    SET XLApp = CreateObject("Excel.Application")

    XLApp.Visible = False

    SET XLDoc = XLApp.Workbooks.Add

   

    

    Set objWorkSheet = XLDoc.Sheets.Add

    SET XLSheet1 = XLDoc.Worksheets(1)   

    SET XLSheet2 = XLDoc.Worksheets(2)

   

    SET DB = ActiveDocument.GetSheetByID("SH01")

   

    'DASHBOARD CHARTS

    XLSheet2.Name = "Dashboard Tab"

    ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard

    XLSheet3.Paste

ExcelFileName = "D:\Excel\QVReportChartsExport" & ".XLS"

    XLApp.ActiveSheet.SaveAs (ExcelFileName)

    msgbox("Report Exported to Excel at " & ExcelFileName)

    XLApp.Visible = True

End Sub

This will store QV Charts as Bitmap image (picture) into Excel.

--

Regards,

Prashant P Baste

HirisH_V7
Master
Master

Hi,

In internet Explorer -> By  Making Preferred Client as Internet Explorer plugin

Access IE.PNG

Then right click bar chart object-> Copy to Clipboard  ->and paste it on excel.

HTH,

Hirish

HirisH
“Aspire to Inspire before we Expire!”