Exporting a pivot chart to excel

[m4u]

When exporting a pivot chart from QV to excel, the output doesnt look like the pivot, since in QV dimensions are marged into one cell, but in excel the dimension value repeats for every single line.

any idea?

Thanks in advance,

[Anonymous]

Corinne,
You can use "Copy Table to Clipboard" and after that paste to excel. You can do it manualy ot by a macro.

[m4u · Accepted solution]

Thank you,

this is a great solution..