Required option: None
Allowed profiles: Brand manager, Sales manager, Sales administrator and Sales representative

LE NEW BLACK allows you to create charts based on the columns and informations displayed on your report. This will help you illustrate data the same way you can create charts on Excel. Furthermore, you will be able to download the chart as an image (PNG format) to use it on external documents.

You have two ways of creating a chart, either in the Generate chart tab or directly from the Set data tab (Grid view) by selecting specific cells and columns. If you wish to save a chart linked to your report and be able to share it, you must create it from the Generate chart tab only. 

• Creating a chart from the Generate chart tab
• Creating a chart from the Set data tab

Creating a chart from the Generate chart tab

To do so follow the steps below:

1. Create a new report or enter an existing report
    
2. Click on Generate a chart tab
    
3. Select the chart type from the drop down menu
    
4. Select a category (column) for the X-axis and values for the Y-axis
    
5. Check the box "Show values" if you want to display those values on the chart directly
    
6. Save the chart by going on the Save report tab and click on Save

Creating a chart from the Set data tab

To do so, follow the steps below:

1. Select the rows/lines of the columns you wish to display in you chart the same way you would do it in Excel
    
2. Right click from your mouse on a selected cell
    
3. Select Chart Range then the chart type, eg. Bar > Grouped (see image below)
   
   💡 Tip : Click on "-" at the top right of the chart to display in the whole report. You can also use the Full screen button at the top right of the page next to Download button to display the chart on the whole page
    
4. Modify the chart by clicking on the 3 dots > Edit Chart if needed 
    
5. Download the chart by clicking on the 3 dots > Download chart

⚠️ Important note: this chart is generated on the fly on your custom report, you cannot saved it on your report. To be able to save a chart linked to a report and share it, you must create the chart from the Generate a chart tab (read the guide here).