Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have one pivot table...with 3 dimensions and 10 metrics.
i want to display 1st 5 metrics under one header...6,7 metrics under one Header...and last 3 metrics under One Header...
is it possible....if it is help me....
Thanks in advance!!!!
Smiley
The easiest way is to use text boxes as headers. See attached example
Hi,
I wanted to do something similar and could not find anything in the chart properties itself, so resorted to using text boxes and arrows to indicate groupings as shown in the example below. I also removed the Caption from the chart so that I could move the other objects closer to the actual chart headings.
Azam