Dear Support,
I’m building a chart at run time base on a large amount of data.
When the code assign the category data to the chart:
chart.NSeries.CategoryData = “=Data!A7:A95656”;
While running,
the real value changed to “=Data!$A$7:$A$30120”
instead of 95656.
If it is a small value, it will keep it.
Any idea?
Thanks!
Gracie