on 07-01-2015 1:42 PM
Dear All,
In my dashboard i am having a column chart is showing as quarter wise sales like Q1,Q2,Q3,Q4.
Is it possible to show the columns colours like Q1 is yellow, Q2 is red, Q3 is blue, Q4 is green?
Can anyone help me on this...
Thanks in Advance.
Regards,
GGK
Hi Chaitanya,
You cannot have different colors for columns in one series.
Each series will have same color. You will have to make use of different series.
And then go to Column chart properties -> Appearance -> Series -> And set the desired color.
If you wish to do this your data should be like the one mentioned above by Ishwarya.
Regards,
Abhilasha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Arrange the values in following format and map the values to chart. Four series will now be created for each quarter. Now give required colour to each series(quarter).
Q1 10
Q2 20
Q3 30
Q4 40
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check the below blog.
http://myxcelsius.com/2013/02/05/multi-colored-column-charts/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.