HI all,
When chart is created (xlColumnClustered ) with sourcing data from the particular range in a sheet it looks fine where it creates horizontal axis with main categorys as "AAA" and sub categories as A ,B,C,D, E and main category as "BBBB" with sub categories "E - F".
The problem is when we delink the source data from the chart the format is getting affected, Please find the image shows two different chart with sourcing data from sheet (range) and with out sourcing .
Note : for delinking i used the vba code as follows .
activechart.SeriesCollection(1).xvalues=activechart.SeriesCollection(1).xvalues
activechart.SeriesCollection(1).values=activechart.SeriesCollection(1).values
chart_issue.png
Looking forward for the assistance.
Bookmarks