excel graph with vba

[Luca]

hi, i've a problem with an excel macro.
I've a sheet with some data and i want to create a graph in another sheet.
anyone can help and show me some tricks to resolve my problem?

Luca

 

[Frank Kabel]

Hi
do you need VBA for this?. Why not use the normal charting
functionality?

 

[Rob van Gelder]

Start the macro recorder, create your graph in another worksheet based on
the data in the first worksheet, stop the macro recorder.

This will give you a start.

 

[y]

Ciao Luca,

follow this link, suggested to me by Wei-Dong XU

http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html#VBAcharts

It's a good start in understanding and troubleshooting your problems with charts.

Anyway I did'nt actually understand your question. The wizard drives you through 5 steps and the
last one allows you to choose if create an embedded chart on a sheet or a stand alone chart in a
sheet. I think the last choice is what you need,

Alex