Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
is there any possibility to export charts to Excel so that it is showing the chart itself, not the values?
Thanks,
Lina
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
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
This can be done by a macro if using the IE plugin.
Search the community for details.
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
Hi,
In internet Explorer -> By Making Preferred Client as Internet Explorer plugin
Then right click bar chart object-> Copy to Clipboard ->and paste it on excel.
HTH,
Hirish