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
|
|||
|
|||
colors of bar charted data don't follow data after sorting
I created a bar chart that has 14 variables. I changed the color of 2 bars to
yellow, 5 bars to blue, and 6 bars to red. When new data is ploted and sorted in a desending order. the colored bars don't follow the variable, they stay in their original location. I have to manualy change the colors to match my ledgend. |
#2
|
|||
|
|||
colors of bar charted data don't follow data after sorting
Hi,
The columns will not be sorted along with you data. You will be to change the colour of the columns after the sorting. You can do this manually or with code or with the use of formula and multiple data series. For the formula/multi series approach see this explanation by Jon Peltier on dynamic charting. http://peltiertech.com/Excel/Charts/...nalChart1.html If you need to use code then post back with the conditions used to determine what columns get which colours. Cheers Andy Frankgjr wrote: I created a bar chart that has 14 variables. I changed the color of 2 bars to yellow, 5 bars to blue, and 6 bars to red. When new data is ploted and sorted in a desending order. the colored bars don't follow the variable, they stay in their original location. I have to manualy change the colors to match my ledgend. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
colors of bar charted data don't follow data after sorting
I have code at the end of this article that explains how to vary colors in a
chart according to category label: http://pubs.logicalexpressions.com/P...cle.asp?ID=390 find the "Color by Category Label (Conditional Formatting)" section. The article's about pie charts, but the code works in column charts too. If the colors vary based on other criteria, you need to adjust the code accordingly. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Andy Pope" wrote in message ... Hi, The columns will not be sorted along with you data. You will be to change the colour of the columns after the sorting. You can do this manually or with code or with the use of formula and multiple data series. For the formula/multi series approach see this explanation by Jon Peltier on dynamic charting. http://peltiertech.com/Excel/Charts/...nalChart1.html If you need to use code then post back with the conditions used to determine what columns get which colours. Cheers Andy Frankgjr wrote: I created a bar chart that has 14 variables. I changed the color of 2 bars to yellow, 5 bars to blue, and 6 bars to red. When new data is ploted and sorted in a desending order. the colored bars don't follow the variable, they stay in their original location. I have to manualy change the colors to match my ledgend. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Colors of columns after sorting data in the supporting table | Booger_Boy | Charts and Charting | 6 | January 24th, 2005 02:41 PM |
Pulling data from 1 sheet to another | Dave1155 | Worksheet Functions | 1 | January 12th, 2005 05:55 PM |
Retaining Data Point Colors while Deleting a previously plotted Column? | Ken Black | Charts and Charting | 4 | October 17th, 2003 03:54 PM |