How to create a Scatter chart in Excel

How to create a Scatter chart in Excel

  1. Click on “Excel”, select a workbook to edit
  2. Select the data for the chart
  3. Click the “Insert” tab
  4. Click on “Insert Scatter or Bubble Chart” icon
  5. Select any one “Scatter” chart from available ones
  6. You have successfully created a Scatter chart in Excel

How to create a Pie chart in Excel

How to create a Pie chart in Excel

  1. Click on “Excel”, select a workbook to edit
  2. Select the data for the chart
  3. Click the “Insert” tab
  4. Click on “Insert Pie or Doughnut Chart” icon
  5. Select any “2-D Pie” or “3-D Pie” chart from available ones
  6. You have successfully created a Pie chart in Excel

How to enable Error Checking in Excel

How to enable Error Checking in Excel

  1. Click on “Excel”, select a workbook to edit
  2. Click “File”
  3. Click “Options”
  4. In the “Excel Options” box, click the “Formulas” tab
  5. Under “Error Checking”, check “Enable background error checking”
  6. Click “OK”

How to insert a SmartArt graphics and add text to it in Excel

How to insert a SmartArt graphics and add text to it in Excel

  1. Click on “Excel”, select a workbook to edit
  2. Click the “Insert” tab
  3. Go to the “Illustrations” group
  4. Click “SmartArt”
  5. In the “Choose a SmartArt Graphic” box, click the “type” that you want
  6. In the “Choose a SmartArt Graphic” box, click the “layout” that you want
  7. Click “OK”
  8. Click “Arrow Control” on the left side of the SmartArt graphic, if text pane is not visible
  9. Click [Text] in the Text pane and then type your text   
  10. Repeat the same for all text panes
  11. You have successfully inserted a SmartArt graphic and added text to it

How to insert threaded comments for discussions in Excel

How to insert threaded comments for discussions in Excel

  1. Click on “Excel”, select a workbook to edit
  2. Select a cell
  3. Right-click the cell and then click “New Comment”
  4. Type your comment in the textbox
  5. Click the “Post button” (or press Ctrl+Enter)
  6. You have successfully inserted threaded comment for discussions in Excel