Pivot to excel

[Anonymous]

Hi

I have a pivottable with 2 columns, where the first column is in percent and the second is with a traffic light gauge. It has the exakt same calculations so it is the same numbers.

However, I would like to export the table to excel and get the traffic light gauge symbol to be exported as well. Right now, if I export to excel it looks like this:

County	Percent	Traffic light gauge
Skåne	67%	67%
Kronoberg	78%	78%

Instead of having a number in the second column I would like to be able to export the traffic light symbol.

Thanks in advance!

[#2]

What you can do is to go to properties, tab title, in section special icons, select copy image to clipboard, then open an excel sheet and paste it. you will have it like an image, I don´t think that is possible to get in excell a gauge into a excel cell.

I hope this is what you are looking for.

greetings!!

[Anonymous]

Thanks! But that wasn't what I was looking for

Do you know if it's possible to choose which columns I want to export?