Adjust pivot table to show all value split by chr(10)
Please see the attached example. In the script you may notice that John has 3 Type values i.e. A, B, and C but the chart shows only the first one - A as the other two values - B and C - are in the not shown lines. I'm looking for an idea to show "hidden" values but keeping them as they are now - in seperate lines.
Re: Adjust pivot table to show all value split by chr(10)
Thanks very much, Miguel. The chart model - several other expressions - requires first option i.e. wraping cell text but in a dynamic way. All other expressions need to be shown in a single line, if I set a given number of lines to wrap all other will also get the given number of lines. I realize this isn't really a problem although this is the only way to present data I have.