Quickly add a chart to report in SalesForce Ligthning

When the button add chart is greyed out in a report created in SalesForce do not panic - a simple manipulation has to be made to be able to create a chart from that report, and the trick can be used anytime when creating reports in SalesForce: group records together for chart generation.


Adding a chart to a report in SalesForce Lightning

When the button add chart is greyed out in a  report created in SalesForce   do not panic - a simple manipulation has to be made to be able to create a chart from that report, and the trick can be used anytime when creating reports in SalesForce: group records together for chart generation.

Solve add chart SalesForce report grayed out: group report data on one field
Add Chart button is disable on my report screen

Get around the greyed out add chart button by grouping data

Open your  report created in SalesForce   and click on the edit button in the top right corner of the report visualization screen to access report options and get around the greyed out button.

The next step is to add a group of data. For example, if you want to report on how many Mister, Miss and Doctors are available in your list of  SalesForce accounts   and  SalesForce contacts   then select the salutation field for grouping.

The raw data that can be used to  exporting data from SalesForce to Excel   in the report table view is now grouped by the salutation field as you can see in the preview tab.

However, data hasn't been set yet and report hasn't been yet updated. To do so, click on the RUN button.

unable to add chart to custom report

Generate chart from report

Back on the report visualization screen, the button Add Chart is now available for data that has been grouped on one field!

After clicking on the add chart button, the chart creation screen will be displayed, with a standard chart visualization selected by default, which might depend on the type of data that was available in the report, and the field used for grouping.

Click on chart properties to change the type of chart used.

Different types of charts are available: bar, column, stacked bar, stacked column, line, donut, funnel, scatter plot, and much more.

Depending on the grouped data, different charts will be available or not for the chart generation from report.

Selecting a donut visualization, the new chart created from report will be available and can be used and reused in  SalesForce dashboards   or for  exporting data from SalesForce to Excel   and create beautiful reports with charts.

Add a Chart to a Report

Frequently Asked Questions

What are the advantages of adding charts to reports in Salesforce Lightning?
Adding charts to reports enhances data visualization, making it easier to interpret complex data and identify trends and patterns.

Yoann Bierling
About the author - Yoann Bierling
Yoann Bierling is a Web Publishing & Digital Consulting professional, making a global impact through expertise and innovation in technologies. Passionate about empowering individuals and organizations to thrive in the digital age, he is driven to deliver exceptional results and drive growth through educational content creation.



Comments (0)

Leave a comment