Menu
How to change the order of colors in a stacking column graph from the bottom up? Default colors come from the top down.
1000
In a chart, click to select the data series for which you want to change the colors. On the Format tab, in the Current Selection group, click Format Selection. tab, expand Fill, and then do one of the following: To vary the colors of data markers in a single-series chart, select the Vary colors by point check box.
Under Chart Tools, on the Design tab, in the Data group, click Select Data. In the Select Data Source dialog box, in the Legend Entries (Series) box, click the data series that you want to change the order of. Click the Move Up or Move Down arrows to move the data series to the position that you want.
If you mean the stacking order of the series, you can set the index property for each series.
example:
If you mean that you just want the colors in a different order, you can define the colors array yourself:
If you mean something else, add more detail to your question to clarify.
152
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
