How to color the monthly bar for each year diff color , for easy visulisation purpose.

[paulyeo11]

Hi All

My goal is show which year have high sales , and how many high sales.

So i like the monthly bar chart show same color for each year.

The bar chart color  like below :-

2017 red

2016 yellow

2015 blue

2014 green

The color can be random color. Hope some one can share with me. Paul Yeo

[paulyeo11]

my qvf

[Anonymous]

On the Bar Chart in Appearance | Colors and Legend try changing Colors to By Dimension | By dimension.

[paulyeo11]

Hi Bill

I have try your suggestion , it turn out every month diff Color , for example every year Jan = yellow

What i need is whole year from Jan to Dec 2017 yellow Color .

It is possible ?

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

[Vasiliy_Beshentsev · Accepted solution]

Hello, like this?

[paulyeo11]

thank you very much