I've tried a little workaround to format the crosstab header using sample data source.
Find the attached workbook! Hope you this will help you out to solve the problem!
Thanks Akarm. It a good idea, but I really need the 'YEAR" to display in the crosstab, so bar chat might not be what I want.
1 of 1 people found this helpful
The "Year" with sales information was shown as text on the updated workbook!
I tried replicating the same as you wish but it doesn't seems good with only text with "year". So I could suggest this chart can be a better alternative for your requirement!