Displaying several series in one diagram helps to compare the individual series better or makes it possible to see multiple series added. You can create grouped or stacked charts as needed.
This is an example on how the data from which you create the charts may be arranged in your Excel file:
Grouped diagrams are particularly useful when you want to compare several data series directly for a wide range of categories.
You can find out how to display multiple data series in a grouped diagram in the section "Create grouped diagrams ".
With stacked diagrams, you can highlight the sum of multiple data series. What you previously viewed individually can be added to these diagrams in your app.
The following chart types show the selected data series in a stacked form:
To learn how to add stacked charts to your app, see the section "Create stacked charts".