If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Color formatting pivot bar chart
I have a bar chart that shows the top 5 40 segments broken down by each
teritory. It graphs good, but I need to color code the segments into their groups. So 1-5 may be one group, 6-13 will be another. When I color code all turn the same color. I would like to conditional format on the worksheet. Can that transfer to the chart? How do I manually make the segments change. Each territory will not have the same top 5 segments, thus using pivot to help with this task. The top 5 are from a generated report. I could bring all 40 but will still want to graph top 5. Thanks. |
#2
|
|||
|
|||
Color formatting pivot bar chart
Hi,
It is important to know what version of Excel you are using for this task. In 2003 this is really not an option in the pivot table, for one thing the pivot chart will reset to the default colors everytime you refresh the pivot table or pivot chart. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "asg2307" wrote: I have a bar chart that shows the top 5 40 segments broken down by each teritory. It graphs good, but I need to color code the segments into their groups. So 1-5 may be one group, 6-13 will be another. When I color code all turn the same color. I would like to conditional format on the worksheet. Can that transfer to the chart? How do I manually make the segments change. Each territory will not have the same top 5 segments, thus using pivot to help with this task. The top 5 are from a generated report. I could bring all 40 but will still want to graph top 5. Thanks. |
Thread Tools | |
Display Modes | |
|
|