Hi guys

I am trying to plot a 3D surface graph. but as the user defined
variables are changed (for example number of elements used for
solution) dimensions of graph is also changing. so what can i do in
order to manipulate the source data array for automatic arrangement of
graph ?

here i tried something but it is not working

Worksheets("Sheet1").ChartObjects(2).Chart.SetSourceData
Source:=Sheets(3).Range(Cells(1, 1), Cells(10, 10))


range is only accepting

range("A1:C10")

type format for this process but this not appropriate
for example I can not write An:Cm for user defined n,m numbers
ie how can I use this format in order to arrange automatically source
data array ? ie I want the program arrange the array size automatically
so that a true graph can be obtained for all cases.

please help!

Source:=Sheets(3).Range(Sheetts(3).Cells(1, 1), sheets(3).Cells(10, 10))

would be the first thing I would try.

--
Regards,
Tom Ogilvy


"MCM" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi guys
>
> I am trying to plot a 3D surface graph. but as the user defined
> variables are changed (for example number of elements used for
> solution) dimensions of graph is also changing. so what can i do in
> order to manipulate the source data array for automatic arrangement of
> graph ?
>
> here i tried something but it is not working
>
> Worksheets("Sheet1").ChartObjects(2).Chart.SetSourceData
> Source:=Sheets(3).Range(Cells(1, 1), Cells(10, 10))
>
>
> range is only accepting
>
> range("A1:C10")
>
> type format for this process but this not appropriate
> for example I can not write An:Cm for user defined n,m numbers
> ie how can I use this format in order to arrange automatically source
> data array ? ie I want the program arrange the array size automatically
> so that a true graph can be obtained for all cases.
>
> please help!
>

thank you very much

it worked!



Tom Ogilvy wrote:
> Source:=Sheets(3).Range(Sheetts(3).Cells(1, 1), sheets(3).Cells(10, 10))
>
> would be the first thing I would try.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "MCM" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi guys
> >
> > I am trying to plot a 3D surface graph. but as the user defined
> > variables are changed (for example number of elements used for
> > solution) dimensions of graph is also changing. so what can i do in
> > order to manipulate the source data array for automatic arrangement of
> > graph ?
> >
> > here i tried something but it is not working
> >
> > Worksheets("Sheet1").ChartObjects(2).Chart.SetSourceData
> > Source:=Sheets(3).Range(Cells(1, 1), Cells(10, 10))
> >
> >
> > range is only accepting
> >
> > range("A1:C10")
> >
> > type format for this process but this not appropriate
> > for example I can not write An:Cm for user defined n,m numbers
> > ie how can I use this format in order to arrange automatically source
> > data array ? ie I want the program arrange the array size automatically
> > so that a true graph can be obtained for all cases.
> >
> > please help!
> >