Making chart lines visible and invisible

  • Thread starter Thread starter Laurel
  • Start date Start date
L

Laurel

I have a line chart and frequently one line will exactly overlap another,
making them indistinguishable. I would like to allow the user to choose
which sets of data to make invisible. What I'm thinking is to put check
boxes that match the various data series. Here are my questions

1 - Is this possible? Presumably I can find an object in the graph that
relates to the series, and it will have a visible/invisible attribute? If
so, could someone give me a boost up here? I have this much info to start
with from an earlier posting.
"Alternatively, you can use VBA to modify the (child) objects in
the Chart. To know the objects in MS Graph, add the Microsoft Graph into
the References of you database and then use the ObjectBrowser to see the
Objects available in MS Graph."

2 - For my purposes I can live with hardcoding the references to the series,
but is there a way to do this dynamically? E.g., generate a checkbox on the
fly in my form for each series that shows up in the chart?
 
Since each line represents a Data Series which corresponds to a Field in the
Field list of your Query, I think you should (dynamically depending on the
CheckBox) change the SQL String to remove the Field from the Query. Once
you remove the Field from the DataSource, the corresponding line will not be
created in your graph.
 
Well, thanks for that common-sensical suggestion!! I guess not everything
needs to be complicated!
 
Back
Top