First, select all the data you wish to be included in the chart, including any Headings, ie the blue shaded region in the graphic below, and then click on the chart wizard tool.

charts1 

 

Step1
Home
Revision
Functions (1)
Functions (2)
Editing
Charting
Customize