This will insert a chart worksheet at the end of the current workbook:

ActiveWorkbook.Sheets.Add _
after:=Worksheets(Worksheets.Count), _
Type:=xlChart

--
Kevin Backmann


"John" wrote:

How do I add an excel Chart to the end of the workbook

ie presubably Charts.Add ?????

Thanks in anticipation

John