Odd issue with Charts(new type) where the legend doesn't show text after loading the query

[Vita]

I have a form that lets me choose an item from a list and it will generate a query and open a chart based on that query.
I know the query works fine. The data shows up as bars and the query works fine on its own.
The Chart Legend doesn't show the text for the Item even though it is set to it.
Sometimes I can get it to show after fiddling with various options and going back and forth between design view and form view but I can't seem to tell what is causing it.



For example earlier I had the legend text loaded for a specific Item. I closed out the chart form and pressed the button to regenerate the query and open the form and it showed the legend text!
I thought I had fixed it so then I tried changing the item to a different item and the legend text was missing again. It's as if it is slow to load the legend text.

I have "me.requery" and "me.refresh" at the end of the Form_Open event too but it still fails to show up.

Any ideas why this is happening?

[Vita]

I have a form that lets me choose an item from a list and it will generate a query and open a chart based on that query.
I know the query works fine. The data shows up as bars and the query works fine on its own.
The Chart Legend doesn't show the text for the Item even though it is set to it.
Sometimes I can get it to show after fiddling with various options and going back and forth between design view and form view but I can't seem to tell what is causing it.

For example earlier I had the legend text loaded for a specific Item. I closed out the chart form and pressed the button to regenerate the query and open the form and it showed the legend text!
I thought I had fixed it so then I tried changing the item to a different item and the legend text was missing again. It's as if it is slow to load the legend text.

I have "me.requery" and "me.refresh" at the end of the Form_Open event too but it still fails to show up.

Any ideas why this is happening?

This link answered my question. The 'Display Name' field was not automatically setting to the value of the item. The code the person posted fixes that issue.
https://answers.microsoft.com/en-us/...8-647194f971f0

If anyone has some useful vba documentation on the newer charts it would be greatly appreciated. The official documentation seems lacking.