Using Named Range to Set DataSource in Chart
 

Hi,

I am trying to use a named Range which has been set in an earlier
function to use as the SourceData for a chart being created in
excel/vba code.

My code looks like this:

ActiveChart.SetSourceData Source:=XValues, PlotBy:=xlRows

When I run this code, only one cell's value from the "XValues" Range
appears on the X-Axis. I know the range consists of more than one cell
with different values. I have also tried setting PlotBy = xlColumns
and that does not work either.

I can create the graph just fine when I select the range and and create
a chart without vba.

I guess one option would be to select the range and see if that works,
but I don't really like to select cells in the code, but if that's the
only option, I'll do it.

Is there something I should be doing differently?

Thanks,
Dylan

Using Named Range to Set DataSource in Chart
 

Hi Dylan,

Try

ActiveChart.SetSourceData Source:=Range("myNamedRange") ', etc

Regards,
Peter T


"Dyl" wrote in message
oups.com...
Hi,

I am trying to use a named Range which has been set in an earlier
function to use as the SourceData for a chart being created in
excel/vba code.

My code looks like this:

ActiveChart.SetSourceData Source:=XValues, PlotBy:=xlRows

When I run this code, only one cell's value from the "XValues" Range
appears on the X-Axis. I know the range consists of more than one cell
with different values. I have also tried setting PlotBy = xlColumns
and that does not work either.

I can create the graph just fine when I select the range and and create
a chart without vba.

I guess one option would be to select the range and see if that works,
but I don't really like to select cells in the code, but if that's the
only option, I'll do it.

Is there something I should be doing differently?

Thanks,
Dylan

Using Named Range to Set DataSource in Chart
 

Peter,

Thanks for your help. Unfortunately this still does not work. I get
the following error.

Run-tine error '1004'

Method 'Range of object '_Global falied

I also tried to set the range in the same procedure, but I still got
the same error. (I had been getting the value from a function earlier)

I'll keep trying. Thanks again for your help!

Using Named Range to Set DataSource in Chart
 

Sounds like there's something wrong with your named range -

MsgBox ActiveWorkbook.Names("myNamedRange").RefersTo

MsgBox Range("myNamedRange").Address(, , , True)

Regards,
Peter T


"Dyl" wrote in message
oups.com...
Peter,

Thanks for your help. Unfortunately this still does not work. I get
the following error.

Run-tine error '1004'

Method 'Range of object '_Global falied

I also tried to set the range in the same procedure, but I still got
the same error. (I had been getting the value from a function earlier)

I'll keep trying. Thanks again for your help!

Using Named Range to Set DataSource in Chart
 

ActiveChart.SetSourceData Source:=ActiveSheet.Range("myNamedRange") ', etc

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Peter T" <peter_t@discussions wrote in message
...
Hi Dylan,

Try

ActiveChart.SetSourceData Source:=Range("myNamedRange") ', etc

Regards,
Peter T


"Dyl" wrote in message
oups.com...
Hi,

I am trying to use a named Range which has been set in an earlier
function to use as the SourceData for a chart being created in
excel/vba code.

My code looks like this:

ActiveChart.SetSourceData Source:=XValues, PlotBy:=xlRows

When I run this code, only one cell's value from the "XValues" Range
appears on the X-Axis. I know the range consists of more than one cell
with different values. I have also tried setting PlotBy = xlColumns
and that does not work either.

I can create the graph just fine when I select the range and and create
a chart without vba.

I guess one option would be to select the range and see if that works,
but I don't really like to select cells in the code, but if that's the
only option, I'll do it.

Is there something I should be doing differently?

Thanks,
Dylan

Using Named Range to Set DataSource in Chart
 

Hi Jon,

ActiveSheet.Range("myNamedRange")
would fail if "myNamedRange" refers to a range that's not on the ActiveSheet

Regards,
Peter T


"Jon Peltier" wrote in message
...
ActiveChart.SetSourceData Source:=ActiveSheet.Range("myNamedRange") ', etc

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Peter T" <peter_t@discussions wrote in message
...
Hi Dylan,

Try

ActiveChart.SetSourceData Source:=Range("myNamedRange") ', etc

Regards,
Peter T


"Dyl" wrote in message
oups.com...
Hi,

I am trying to use a named Range which has been set in an earlier
function to use as the SourceData for a chart being created in
excel/vba code.

My code looks like this:

ActiveChart.SetSourceData Source:=XValues, PlotBy:=xlRows

When I run this code, only one cell's value from the "XValues" Range
appears on the X-Axis. I know the range consists of more than one cell
with different values. I have also tried setting PlotBy = xlColumns
and that does not work either.

I can create the graph just fine when I select the range and and create
a chart without vba.

I guess one option would be to select the range and see if that works,
but I don't really like to select cells in the code, but if that's the
only option, I'll do it.

Is there something I should be doing differently?

Thanks,
Dylan

Using Named Range to Set DataSource in Chart
 

Of course. I was indicating that perhaps Range("") needs to be more fully
qualified.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Peter T" <peter_t@discussions wrote in message
...
Hi Jon,

ActiveSheet.Range("myNamedRange")
would fail if "myNamedRange" refers to a range that's not on the
ActiveSheet

Regards,
Peter T


"Jon Peltier" wrote in message
...
ActiveChart.SetSourceData Source:=ActiveSheet.Range("myNamedRange") ',
etc

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Peter T" <peter_t@discussions wrote in message
...
Hi Dylan,

Try

ActiveChart.SetSourceData Source:=Range("myNamedRange") ', etc

Regards,
Peter T


"Dyl" wrote in message
oups.com...
Hi,

I am trying to use a named Range which has been set in an earlier
function to use as the SourceData for a chart being created in
excel/vba code.

My code looks like this:

ActiveChart.SetSourceData Source:=XValues, PlotBy:=xlRows

When I run this code, only one cell's value from the "XValues" Range
appears on the X-Axis. I know the range consists of more than one
cell
with different values. I have also tried setting PlotBy = xlColumns
and that does not work either.

I can create the graph just fine when I select the range and and
create
a chart without vba.

I guess one option would be to select the range and see if that works,
but I don't really like to select cells in the code, but if that's the
only option, I'll do it.

Is there something I should be doing differently?

Thanks,
Dylan