Hi all..
I'm having a problem here..
I am foing to develop a VBA application here..
And the application will be linked to a workbook which has a pivottable and a pivot chart in it..
The problem is the the pivot chart color seems to be dull..So i changed the default color the the color that i like..
After that i think the color would be nicer if i put some effects...
After i satisfy with the appearance, i choose another query from the pivot table..or in other words i refresh the data with another option...
This time the effects of the chart color is gone..eventhough i save the workbook earlier..besides color, what makes me so tense is if i set the value font alignment to 90 degree and smaller the value font, then it all will be gone after i refresh the chart with other data option...
how to make the setting remains in pivot table??does anyone know??
please!!!