To Create a Chart in Excel

After your data is set up,

Create a chart by clicking the chart wizard button.

STEP ONE:  This will bring up the chart wizard.  Choose the style of chart your want.

STEP TWO:  Take a look at the chart.  It should look how you want it to here.  If not, you probably highlighted empty cells,

set up your table wrong.

STEP THREE:  FILL IN YOUR TITLES, X AND Y AXIS, IF NECESSARY

STEP FOUR:  Finish your chart by selecting as new sheet.