Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Color on Pivot Chart | Charts and Charting in Excel | |||
Pivot Chart Refresh cancels all chart formatting | Charts and Charting in Excel | |||
Pivot chart, macro to change color | Charts and Charting in Excel | |||
Pivot Table border formatting and pivot chart formatting | Excel Discussion (Misc queries) | |||
pivot table chart color formatting wont stay | Charts and Charting in Excel |