How to change empty ranges from a plot series without generating e

=?Utf-8?B?bHVpemF2YWxh?=

Guest

Posts: n/a

8th Aug 2006

I am writting a macro that updates the range of a set of series in a plot.
The issue is that some of the ranges contain empty cells. When trying to
change the ranges of series with empty values excel returns the error "Unable
to set the Values property of the Series class".

Any ideas

« How Do I increase a date by 90 days? | What formula figures less than & greater than? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If I do not plot empty cells, how do I change the category axis?	=?Utf-8?B?QW5kcmV3IEVkbW9uZHM=?=	Microsoft Excel Charting	0	2nd Aug 2006 04:41 PM
can i change plot area colors for different date ranges	=?Utf-8?B?c3RldmU=?=	Microsoft Excel Charting	1	27th Jun 2006 08:47 PM
chart data series -- plot a table as a single series	=?Utf-8?B?aGpj?=	Microsoft Excel Charting	7	20th Sep 2005 05:52 PM
line charts - error in series should not plot (empty)	NorTor	Microsoft Excel Programming	2	10th Aug 2005 04:27 PM
Ineffective change of plot order in series formula	=?Utf-8?B?TGVzbGll?=	Microsoft Excel Charting	5	30th May 2004 02:15 AM