Q. How do I put a chart in Excel?

Answer

  1. Enter the data to be graphed or charted.  For example here is some student data:       chart 

2. Highlight data to be graphed. Do not include the row with heading titles, only the information you want to graph so in this example we will use student names and the numbers or the homework points. If your worksheet looks like the one above; put your cursor in cell A3, click hold the mouse button down and drag to cell B7. Highlighted data should look like the image below:

 

highlight

 

 

 

 

 

 

 

 

3.  Select the Chart Wizard. This is done by going to the Insert menu and selecting a type of Chart. You can also click on the Chart Wizard button on the Standard toolbar.

4. I chose a Bar Chart, so if you notice Chart Wizard will automatically add the chart to your spreadsheet.  This is what a Bar Chart may look like:

 chart                                                        

 

 

 

 

 

 

 

                                 

Topics

  • Last Updated Jun 19, 2017
  • Views 7
  • Answered By Ryan Mays

FAQ Actions

Was this helpful? 0   0

Contact Us