Hi,
I have several charts in a Excel file, some charts not showing Axis-X not showing actual Label, instead showing 1,2,3...
Because I have macro to hide then unhide Rows to show to unshow certain charts.
Whatever charts until hide status, will not display Axis-X correctly.
In my case, hiding Chart is a must. I also found out this issue only happen, when the Chart and the Data Table are in same worksheet.
Means, if Chart link to same table but in another worksheet, hide and unhide will not facing this issue. It just work.
For more information please refer to below link:
Stackoverflow
