+ Start a Discussion
Greg FinzerGreg Finzer 

How to export bar chart report?

I have a standard report in Salesforce that has a bar chart on it.  When I export it to excel it just has the detail and not the bar chart.  How do I include the bar chart?
Best Answer chosen by Greg Finzer
Raj VakatiRaj Vakati
Its know issue 

Please refer this link 


https://success.salesforce.com/ideaview?id=087300000006n4zAAA
https://success.salesforce.com/ideaView?id=0873A0000003UNuQAM


 

All Answers

Raj VakatiRaj Vakati
Its know issue 

Please refer this link 


https://success.salesforce.com/ideaview?id=087300000006n4zAAA
https://success.salesforce.com/ideaView?id=0873A0000003UNuQAM


 
This was selected as the best answer
Alain CabonAlain Cabon
Hi,

The workaround is difficult to code by using the fact map of your report (if complicated data) and alasql or excel add-in (javascript) to mimic the current standard export of report in excel.

A button call a small visualforce page with remote accesses in javascript to the fact map (apex controller) and generates on-the-fly an excel file (table and chart).

Visualforce Export Excel Report Using Javascript Remoting and AlaSQL
https://nitinkhunalsalesforce.wordpress.com/2016/10/27/visualforce-export-excel-report-using-remote-action-and-alasql/​​​​​​​ (https://nitinkhunalsalesforce.wordpress.com/2016/10/27/visualforce-export-excel-report-using-remote-action-and-alasql/)
https://github.com/agershun/alasql/wiki
https://github.com/agershun/alasql/wiki/Google-Charts

Work with Charts using the Excel JavaScript API 03/19/2019 (no sample with VFP/apex but the best JS API if that works):
https://docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-charts

Get the exact data of the report in apex:
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_analytics_report_data.htm
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_analytics_fact_map.htm

 
MARCOS LILLO RAMOSMARCOS LILLO RAMOS
It is possible: 
  1. Create a dashboard
  2. Add report to dashboard
  3. Open the chart in full screen
  4. Press button download (it will download with full chart in png file)
Hope it helps you