MicrosoftIt's definitely exciting to see modern charts added to Access. But, after playing around with the new control a bit in Access 2019, it appears they're not as robust as the old pivot charts yet. Hopefully they prove to be popular and the team can enhance them in the future :)
I included an image below of a chart I'd like to recreate with the new chart control. It illustrates two of the most important things I'd like to accomplish:
1. Show tool tips as the user hovers over data points
2. Vary the fill color for different points in the same series
Regarding #2, in this particular example, analysts use the chart as a guide to determine the number of quarters that will be used to generate a trend line for future prediction. They move the slider bar to select the number of quarters and the chart dynamically fades out the unselected quarters and redraws the new trend line. With the old pivot charts, we would simply modify the fill color of an element of the points collection. I don't see that capability in the object model for the new chart object. I can get the same final look by dynamically modifying the chart's row source to include multiple series that look like a single series. But requerying the row source in the new chart object is laggy and visibly redraws the entire chart, causing it to disappear and reappear. I can get a smoother effect by playing with Echo but the result is still not clean.
