[]
You can set the chart in the following ways:
Using the Chart Control on sheet
Using the Chart Control
Creating Plot Types
Connecting to Data