J
johnny
I have a number of pivot charts that displays the same kind of data (hours
registered on different projects). I want to use the same color for the same
project in the different charts, but when I change the order of the projects,
Excel changes the color automatically. Is there a way to avoid this?
In the charts where I changed the order, I have tried to match the color
Excel produces automatically, but I am not able to reproduce it. How can this
be found?
Finally, is it possible to change transparency and retain the automatic color?
I use a bar chart with series overlap in Excel 2007.
Grateful for any help
registered on different projects). I want to use the same color for the same
project in the different charts, but when I change the order of the projects,
Excel changes the color automatically. Is there a way to avoid this?
In the charts where I changed the order, I have tried to match the color
Excel produces automatically, but I am not able to reproduce it. How can this
be found?
Finally, is it possible to change transparency and retain the automatic color?
I use a bar chart with series overlap in Excel 2007.
Grateful for any help