HELP With Charts using VBA in excel

[Nick34]

I have created a chart sheet using VBA in excel, but I can not figure out how to input the data I want to graph using VBA. Can anybody help me?

 

[SkipVought]

Nick34,

Have you tried recording creating a chart? Turn on your macro recorder, create a chart, turn the recorder off and inspect the VBA.

;-)

Skip,

http://www.TheOfficeExperts.com

 

[Nick34]

I did that, and now I am getting it to work.

I was also wondering if you know how I could tell excel to check to see if my chart is there, and if it is delete it?

I would then like to re-create the chart based on different data.

 

[SkipVought]

A Chart can be embedded, in which case it is a ChartObject or a sheet in which case it is a Chart.

To delete all charts in a workbook...

dim cht as cahrt, ws as worksheet, co as chartobject
for each cht in activeworkbook.charts
  cht.delete
next
for each ws in worksheets
  for each co in ws.chartobjects
    co.delete
  next
next

Skip,

http://www.TheOfficeExperts.com

 

[Nick34]

thanks.