To display multiple series in a pie chart, you can follow these steps:
- Select the data range that you want to include in the chart, including the series names and values.
- Click on the "Insert" tab in the ribbon.
- Click on the "Pie" chart icon and select the type of pie chart you want to create.
- The pie chart will be created with the first series displayed. To add more series, right-click on the chart and select "Select Data".
- In the "Select Data Source" dialog box, click on the "Add" button to add a new series.
- In the "Edit Series" dialog box, enter the series name and select the data range for the series values.
- Repeat steps 5-6 for each additional series you want to add.
- Click "OK" to close the "Select Data Source" dialog box.
- Your pie chart should now display all the selected series.
To force the pie chart to use the most recent/lowest data series, you can use a formula to determine the location of the lowest non-empty cell. Here's an example formula you can use:
Formula:
=CELL("address",INDEX(B:B,MATCH(9.99999999999999E+307,B:B)))
This formula will return the address of the last non-empty cell in column B. You can then use this address to define the data range for your chart.