Advanced MS Excel

• Creating a pie chart


  1. Select data

  2. Go to Insert tab

  3. Click on Pie char

  4. You can select Doughnut Pie, 3D Pie, 2D Pie

  5. Add data labels
• Pie chart slice options

  • Angle of first slice - It is changing the angle of the slice
  • Pie explosion - The pie is separated, making it look like they exploded.
• Separating pie chart slices


  1. Click on slice

  2. Drag slice outwards
• Hiding pie chart slices

  1. Double click slice

  2. Set no fill

  3. Remove data label
• Pie charts can only display one column of data
• Creating a column chart

  1. Select data

  2. Go to Insert tab

  3. Click on Column chart (You can also use Alt F1)
• Issue with column chart when first column is labels

  Column chart interprets first column as data series
• Fixing column chart with labels in first column

  1. Go to Select Data

  2. Edit axis labels

  3. Select label range
• Changing column chart to bar chart

  1. Select chart

  2. Change chart type to Bar chart
• Bar charts make it easier to compare values across categories
• Creating a column vs line chart

  1. Select the data

  2. Click the Change Chart Type

  3. Select Combo Chart
• Column vs line chart

  Allows displaying two data series with different chart types (column and line) on the same chart
• Adding secondary axis to column vs line chart

  1. Double click on column series

  2. Set to secondary axis
• How to transfer your data to column chart

  • Click Select Data
  • Click Edit
  • Click the Cell Numbers
  • Click OK
• How to filter your bar chart

  • Press the two or more data that you want to compare so that other data won't show up.