chart series data corrupted when chart has no data

=?Utf-8?B?dGltcA==?=

Guest

Posts: n/a

11th Apr 2006

I have a routine that allow the user to easily redefine the data ranges (by
x-axis dates) for a number of charts each with a number of series (in a
single workbook)

If the user specifies an x range without any y data, excel plots a blank
chart, but the next time it fails because the formula is corrupted. Checking
for the presence of data for each series in each chart beforehand is a chore
I'd rather avoid.

Anyone know if there is another solution?

thanks

« Option Base error... | Don't show the steps in a macro »

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
Not plot a data series in a chart but still display in data table	mebp	Microsoft Excel Charting	1	19th Mar 2010 05:13 PM
automatically expand chart data series as data is added	=?Utf-8?B?amxhcnNvbg==?=	Microsoft Excel Charting	1	9th Mar 2006 10:31 AM
chart data series -- plot a table as a single series	=?Utf-8?B?aGpj?=	Microsoft Excel Charting	7	20th Sep 2005 05:52 PM
Plotting multiple data series in a chart with Chart Wizard - HOW?	Jack Lamberton	Microsoft Access Reports	1	15th Dec 2003 07:00 AM
can I hide a series in a stacked bar chart but keep the series in the data table	jcknortheast	Microsoft Excel Charting	1	5th Dec 2003 10:53 AM