Layouts are not data sources. The layout on which you choose to put the chart object specifies a "table occurrence" in Layout setup | Show records from. This table occurrence then establishes the context for whatever data you specify for your chart in the data source options.
Yes, but you still have to find and sort records to display on the chart. Since these are not on the chart layout you have to use another layout to do this. That's what I'm calling the data source. Not so?
Since these are not on the chart layout you have to use another layout to do this.
There are several data source options that you can select for your chart. They all start from the "context" of your chart object's layout--the layout where you have placed your chart.
If you specify the found set as your data source, you find and sort records on your chart's layout. If you specify charting from a related table occurrence, then the relationship between your layout's table occurrence to the specified table occurrence determines how the current record on your chart's layout matches to records in the related table and thus controls what data is used in the chart. (Think of this as charting the values shown in an unfiltered portal to a related table.) The third option is to set up delimited data as the source of values for your chart object. This will either be return separated data stored in a text field of the current record on your layout or a calculation--either in a field or specified in chart setup that produces such a list of values. ExecuteSQL is often the tool of choice for producing such a list, but any of these calcuations, whether defined in chart setup or in a field, also evaluate from the context of the current record on your chart's layout.
Thanks PhilModJunk, that was a big help. I wish FM "help" is as clear as you are.