Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart color
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart color
johnny wrote:
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 I too am frustrated by the lack of formatting control on pivot charts. To get around this, sometimes I create a separate worksheet that basically copies the values from the pivot and base the chart on the copy. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart Color | Excel Discussion (Misc queries) | |||
chart by cell color or * | Charts and Charting in Excel | |||
Chart axes color index vs font color index | Charts and Charting in Excel | |||
2 color bar chart? | Charts and Charting in Excel | |||
How do I connect cell color to bar chart color? | Charts and Charting in Excel |