Chart data

[Rita]

I have a chart in a form.

When I edit the form I can define how the chart looks, and
that is also how it looks when the form is displayed.

Almost...I have an issue with the data series. For the
chart control I can create the row source as an SQL
statement and set the column count to match what I want to
show. In form view the column count takes effect - whereas
in edit view I have the series I originally had... when I
show the charts data sheet I have series I am not even
including in the sql anymore.

How do I make the chart in edit mode reflect the "Row
Source" sql?

 

[Penguin]

If your data source (query or SQL) has more than the default of the
graph wizard then just set the enabled property of the graph to Yes
and the Locked to No. Then open the form and double click on the
graph. This should fill in the data from the data source.

Hope this helps.