Unable to set the XValues property of the Series class

ramkumar_cpt · #1 11-24-2005, 07:24 AM

Hi

I have one sheet. It contains some charts. I want to put the XValues use macro. But I am unable to run this macro. I got error as Unable to set the XValues property of the Series class.("Run time error 1044"). Anybody can help me?

My macro code is:

ActiveWindow.Visible = False
Windows("FullTemplate.xls").Activate
Range("I22").Select
ActiveSheet.ChartObjects("Chart 1031").Activate
ActiveChart.ChartArea.Select
ActiveChart.SeriesCollection(1).XValues = Worksheets("MonthlyData").Range("B2:B5")
ActiveChart.SeriesCollection(1).Values = "=MonthlyData!R2C5:MonthlyData!R30C5"

Note: I am using Line chart. Pls help me.

Thanks in advance.

Ram.

#2 11-25-2005, 10:15 AM

Hi,

Are you sure that was where the code failed.
This line looks the more likely candidate.

ActiveChart.SeriesCollection(1).Values =
"=MonthlyData!R2C5:MonthlyData!R30C5"

try changing the references to,
ActiveChart.SeriesCollection(1).Values = "=MonthlyData!R2C5:R30C5"

Cheers
Andy

ramkumar_cpt wrote:
> Hi
>
>
> I have one sheet. It contains some charts. I want to put the
> XValues use macro. But I am unable to run this macro. I got error as
> Unable to set the XValues property of the Series class.("Run time error
> 1044"). Anybody can help me?
>
> My macro code is:
>
> ActiveWindow.Visible = False
> Windows("FullTemplate.xls").Activate
> Range("I22").Select
> ActiveSheet.ChartObjects("Chart 1031").Activate
> ActiveChart.ChartArea.Select
> *ActiveChart.SeriesCollection(1).XValues =
> Worksheets("MonthlyData").Range("B2:B5")*
> ActiveChart.SeriesCollection(1).Values =
> "=MonthlyData!R2C5:MonthlyData!R30C5"
>
>
> Note: I am using Line chart. Pls help me.
>
>
>
> Thanks in advance.
>
> Ram.
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

ramkumar_cpt · #3 11-28-2005, 12:15 AM

Hi,

Andy. yes that is my mistake. Now i have corrected that error. But again i got the same error as Unable to set the XValues property of the Series class.("Run time error 1044"). Pls help me?

This time my coding is:

ActiveSheet.ChartObjects("Chart 1030").Activate
ActiveChart.ChartArea.Select
ActiveChart.SeriesCollection(1).XValues = "=MonthlyData!R2C1:R30C1" ActiveChart.SeriesCollection(1).Values = "=MonthlyData!R2C2:R30C2"
ActiveChart.SeriesCollection(2).XValues = "=MonthlyData!R2C1:R30C1"
ActiveChart.SeriesCollection(3).XValues = "=MonthlyData!R2C1:R30C1"

#4 11-28-2005, 06:00 AM

Does your range contain empty cells?

ramkumar_cpt wrote:
> Hi,
>
> Andy. yes that is my mistake. Now i have corrected that error. But
> again i got the same error as Unable to set the XValues property of
> the Series class.("Run time error 1044"). Pls help me?
>
> This time my coding is:
>
> ActiveSheet.ChartObjects("Chart 1030").Activate
> ActiveChart.ChartArea.Select
> *ActiveChart.SeriesCollection(1).XValues =
> "=MonthlyData!R2C1:R30C1"* ActiveChart.SeriesCollection(1).Values =
> "=MonthlyData!R2C2:R30C2"
> ActiveChart.SeriesCollection(2).XValues =
> "=MonthlyData!R2C1:R30C1"
> ActiveChart.SeriesCollection(3).XValues = "=MonthlyData!R2C1:R30C1"
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

ramkumar_cpt · #5 11-29-2005, 09:42 AM

Yes Andy. My cell has contains no value. it is empty. so what?

#6 11-29-2005, 10:15 AM

As a test put some values in the empty cells and try your code. It
should work.

Once you have established the problem is empty cells you can experiment
by populating the first empty cell and seeing if the code still works.

Then you need to update your code to check the status of empty cells and
put something in them temporarily so your code runs. Then clear those
cells when finished.

Cheers
Andy

ramkumar_cpt wrote:
> Yes Andy. My cell has contains no value. it is empty. so what?
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)