Set source data immediately when creating a chart?

[dmasters4919]

Right now I have this to create a chart. As you can see I have to set the source data after creating the chart which is causing problems, because when the chart is initially created it will default to the data that's on the active cell. I would prefer not to have to use the select statement to select my range on the worksheet before I make a chart every time because I know that's sloppy. However, I can't figure out how to set the source data in the same line the chart is created.

Please Login or Register  to view this content.

[dmasters4919]

Trying this one more time