Hi,
I have a pivot table where the measure values are printed as one character unicode with black circles chr(11044) .
based on the different conditions i have changed the color of black circles to Red,Amber,Green
When i export to excel this table the color of circles are not preserved and all look black color circles.
When i export as image from the chart the color of chart is preserved and it looks as expected.
(pivot table has 180 rows and when i set the dimensions hieght and all then complete table is exported as image)
however business requires the data to be exported automatically as image for which i tried to use Nprinting.
while exporting via nprinting As image only first 15-16 rows are exported as image.
Question 1) How do I export the entire pivot table with 180 rows as image?
Question 2) Also is there any option where above functionality can be achieved by exporting the data to excel with the colors preserved?