Posted to microsoft.public.excel.programming

[email protected] harm.charles@gmail.com is offline

external usenet poster

Posts: 24

Copy chart to new location

Hi,

I recorded a copy of a chart and paste to new location on a work sheet
and recorded the value for the chart. I'm trying to use vba to do
this, but the following code has an error. What is wrong with it.

Code:

ActiveChart.SeriesCollection(1).XValues = "=reject!R2C" & Fcol + 1 &
":R3C" & Lcol - 2 & """"

Error Unable to set XLValues of Series class.

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
chart a location	Jamie	Excel Discussion (Misc queries)	0	January 29th 10 06:46 AM
How to specify location for chart in VBA	Fred Smith[_4_]	Excel Discussion (Misc queries)	1	February 27th 08 01:50 PM
Copy Chart and Insert in new Sheet as picture over the same location	TFriis	Excel Programming	1	January 22nd 08 04:27 PM
Chart location	hederman	Excel Discussion (Misc queries)	1	December 21st 07 12:13 AM
location of chart	bludik	Charts and Charting in Excel	4	May 24th 05 12:24 PM

All times are GMT +1. The time now is 05:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us