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.