Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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!!
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?