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