| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Colors of columns after sorting data in the supporting table
When creating a chart off of a table, the colors of each column appear to be
in the order of their display in the chart. For example, let's say I have January data as red, February data as white and March data as blue. Then I sort the table in the Excel sheet by value. Now the labels are ordered February, March, January. Well, now the first column (February) is red, the second (March) white and the third (January)blue. Is there a method to hard-code the column color to the data label in the charts rather than simply the order that the data appears? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is the order of my data table opposite from graph? | Charts and Charting in Excel | |||
| Using Microsoft Query data in a pivot table. | Charts and Charting in Excel | |||
| changing proportion of chart and data table | Charts and Charting in Excel | |||
| multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
Threaded Mode
