Excel 2010.
I have 3 separate measures to plot as a cluster, for several products, for several time periods.
All works well except I cannot see a way to display the products name. It seems that on the bottom axis I can show the time period only.
Do I have to rig this to concatenate both product name and month name as a single column ?
Also, strangely, the category legend includes the products name...which is incorrect.
I had to include the products as the 1st data series in order to get the clustering effect.
Anyone experience something like this ?
When I attempted this as a pivotchart, I got closer. They key is the multilevel Category labels setting.
In the case of the pivotchart, the second level was obliterated. I have no idea how to control that as the settings for rotation, etc. seem only to apply to the first level.
Bookmarks