How To Create A Graph In Excel

[AAE]

is it possible to have data in sheet 1 and then have only the Graph displayed in sheet 2

I find it easier to create the chart on the same sheet as the data you want to plot then moving the chart to the other sheet.
You may select a chart the use the standard cut and paste actions to move it.

[rich_cirillo]

Hi

I now plan to have the graph on the same sheet as the data......can this be done with VBA?

Thanks

Rich