OverviewStep 1 creating a seriesStep 2 adjust row heightsStep 3 add column totalsStep 4 add a names columnStep 5 add column headersStep 6 add currency formattingStep 7 freeze the column headingsStep 8 add a Salary columnStep 9 add a conditional formulaStep 10 add a COUNTIF formulaStep 11 utilising binary cellsStep 12 applying Conditional FormattingStep 13 adding text cellsStep 14 adding an AVERAGEStep 15 adding calculationsStep 16 adding a FilterStep 17 add a Pie Chart graphicStep 18 using the IF and CONCAT functionsADDITIONAL Work with timesADDITIONAL PrintingAdvanced Topic VLOOKUPsAdvanced Topics Pivot Tables
Excel training
First written: Feb-2024
last changed Mar-2024

Adding a pie chart

  1. Using the filter on the Daily Rate column, select Sort Smallest to Largest

  2. Select the cells D9 through to D21

  3. Hold down the keyboard [CONTROL] button and select the cells B9 through to B21

  4. Select the Insert menu option from the top of the workbook - then select - Using the control button on your keyboard, select the last 10 Names + the pie chart icon from the Charts tab to see a new pie chart added to the worksheet

  5. Right click on the pie-chart legend and select Format Legend

  6. Using the sidebar - set the legend to position on the right

  7. Right click on any one of the pie-chart slices, and select "Add Data Labels"

  8. Right click on any one of the slice data labels and select "Format Data Labels" - then from the right sidebar select Label Position "Outside End"

  9. Note, if you were to play with the table column filters then this will adjust the chart data being shown.

  10. Now mouse right-click on the chart and select "Cut"

  11. Now we want to put this chart on a new worksheet - select the "+" on the bottom of the Excel workbook (to the right of the "Sheet1")

  12. On the new "Sheet2" worksheet, click [CONTROL] V to cut and paste the chart onto the new worksheet

  13. Double click on the "Sheet2" worksheet name from the tabs at the bottom of the Excel workbook and change the name from "Sheet2" to "Charts"