Source Data Syntax

  • Thread starter Thread starter George Wilson
  • Start date Start date
G

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
 
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
 
Back
Top