Forum Discussion
Column and Dot Chart - Colors and Labels
Trying to show the absolute number and % (secondary Y-axis) for each category, so each column should have its own color. Using Line and Stacked Column Chart, I put the absolute number as column valu...
Hi nadavbi ,
1. Use X axis field on legend, then line chart will become a dot chart, now you can change color of Column as well as dots manually. So once you have to do the exercise, that each axis item color for bar and dot can be kept same.
2. You should also get data label opetion for Column and line plot.
I have not set colors myself, but you will see options for both column and dot/line plot.
Hope it helps.