Hi. I'm trying to copy a pivot table into a new worksheet using chart.copy. That turns the data sources into value lists (so not linked back to the pivot table). That's what I want because I want a graph suitable for printing, without all of the pivot table buttons. The problem is that if I have multi-level categories, they get munged up in the copy, for instance, in the pivot table I'd have this:
| 1 | 2 | 1 | 2 |
| 1 | 2 |
And in the copied table, I have this:
| 1 1 | 2 | 1 2 | 2 |
Is there any way I can copy with the multi-level categories intact?
Thanks.
| 1 | 2 | 1 | 2 |
| 1 | 2 |
And in the copied table, I have this:
| 1 1 | 2 | 1 2 | 2 |
Is there any way I can copy with the multi-level categories intact?
Thanks.