OLE using Excel objects

The object of my code is to utilize Excel
objects to graph my data on a form.
Plus, I can change the title of the graph by
double clicking the title just like I can do
in Excel.

My question is:

1. Which method is the best? Using ole automation or other methods?

2. If OLE is used, what object(s) do I have to
insert, Ms Excel chart or Ms Excel worksheet or
both?

You are highly appreciated if you can privde an example or make some suggestions.

(BTW, I am new in this area)

Use the MSChart control. For a simple graph it's easier than Excel.

Go to VB help, MSChart Control > Overview

It has the four basic code pieces need to make a graph.