Access/MS Graph Question...
I am encountering a few problems with MS Graph through Access VBA. Any help would be appreciated.
1) The graph variables do not update fast enough to pull out the data to update the graph during creation at runtime (For instance: I would like to reset the CrossesAt to the MinimumScale value so that my Axis labels are in the correct place when the value drops below zero. Also, I would like to be able to read the SeriesCollection.Count value.).
What ends up happening is that the default variables from the stored graph in the form are read instead of the new information from the query creating the graph. Once the graph has been opened the data is read correctly though (tested by adding a command button to the form and spitting out a message box with the information.) I need to be able to do this during creation at runtime.
Is there any way to fix this? I've tried:
None of these have worked.
2) Is there any way to read Text information from the Legend or Series Collections? I want to change the color of the lines in my bar graph depending on the name of the series (For instance: I would like to change the color of my lines and points to red for the series named "TOTAL".).
I have tried using typical terms like Caption, Text, Value, and Name with each of the items but these are not recognized.
or ...Chart.Legend.LegenEntries(1).____ etc...)