Forum Discussion

kongyuancn's avatar
kongyuancn
Icon for Helper II rankHelper II
5 years ago
Solved

Auto color for Clustered column chart

Hi All, I have some data and what to show as a column chart.    Lets say I have a table like this: Name        Value Name1 90 Name2 22 Name3 78 Name4 65 Name5 28 Name6 45 Name7 50 Name8 6...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi kongyuancn 

    There's no automatic way to use the in-built colors as you want to do.

    You either manually assign colors or use a conditional formatting rule to assign colors.

    Regards

    Phil

petrified_goose's avatar
petrified_goose
Regular Visitor
3 years ago

I'm late to this thread, but you could possibly change your visualization from a clustered column chart to a stacked column chart. You can do this in the visualizations pane.

You should get the colors you're lookin for without changing the shape of thr graph. 

Hope this helps!