Source Data Syntax

[George Wilson]

Does anyone have detailed information related to the
syntax used in the source data dialog for a chart? The
syntax is used differently from that in a regular formula.
Is there any way to acctually use a formula in the source
data to dynamicaly assign different source data
conditionally? Any helpful suggestions will be appreciated.
TIA
George

 

[Tushar Mehta]

To get whatever syntax you need, turn on the macro recorder (Tools |
Macro > Record new macro...) do whatever it is you want through the
GUI, turn off the recorder, and switch to the VBE. XL will -- in most
cases -- give you the necessary syntax.

You cannot use a formula as the source data. However, a named formula
is OK. For how, see the first 2 links in the Excel/Tutorials/Dynamic
Charts page of my web site.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions