can someone please help me out.

i have a chart on a page that uses the range c4:e16. it defaults to plot by
rows. i am just looking for a simple macro to change it to plot by columns.
can i even do this?

i tried the following, but get an error 9, subscript out of range. i right
clicked the chart and chose assign macro, just to find the chart number, and
it tells me it is chart4, so that's what i tried.

Sub Change_Chart()
Sheets("Monthly Totals").Select
Charts(4).SetSourceData Source:=Sheets("Monthly Totals").Range("c4:e16"), _
PlotBy:=xlcolumns

End Sub

--


Gary