Hi excel chart experts,

I am trying to figure out how to present in the chart table (the table below the chart) the main titles, but I couldn't. Also cannot find a creative way to modify the data table.

I have data which are categorized into different part. e.g. Main title is Fruit, then there are data about apple, mango, orange, etc. Another Main title is Beverage, the there are data about milk, soda, beer, etc.

I draw the chart and want to display the table below the chart. However, i cannot take out the main title and then present only the subtitles. What it shows me is it includes the main title in every subtitles.

Could anyone have any ideas?

Thanks,
Sarin