Formula property of a series in a chart

Posted to microsoft.public.excel.programming

Ali[_2_]

external usenet poster

Posts: 3

Formula property of a series in a chart

Hello
I can acquire the formula of a series in a chart if the values sourced are valid figures, but when im sourcing to values which are all #NA(), so not visible on the chart, i can seem to acquire the formula of that series?? anyway round this? apart from changing the #NA() to zero's.

many thanks ahead?

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
Excel Chart Series Values Property Size Limitation	Pete	Charts and Charting in Excel	9	January 14th 08 03:03 PM
Unable to Set the XValues Property of the Series	KathyC	Charts and Charting in Excel	5	January 4th 07 09:26 PM
Unable to set the formula property of the series class	Malhar	Charts and Charting in Excel	1	July 24th 06 05:50 PM
"Unable to set the Formula property of the Series class" with a tw	PeterQ	Charts and Charting in Excel	1	February 15th 06 07:37 PM
Unable to set the XValues property of the Series class	ramkumar_cpt	Charts and Charting in Excel	5	November 29th 05 02:13 PM

All times are GMT +1. The time now is 11:44 PM.

Menu

About Us