Updating Chart Source range during Sub optionbutton_click

Hi guys,

How do I change the source data range for my chart named "Chart41" on my worksheet "Schedule Summary" during Sub OptionButton4_Click()?

When option button 4 is clicked i want the chart to update. The source data should come from sheets("Graph_Data") and the range should be "A1:F9" on this sheet

I keep getting an error saying "Unable to get the ChartsObject property of the Worksheets class" when I try and do it. Here is my code so far..

Please Login or Register  to view this content.

Regards
Jordan

Any input on this one guys?

Jordan