Charts

ejacksonBPT

Why are the columns in the first chart all showing the same. I tried to change the color but when i hit the drop down my other categories are not listed. Only option is Column3.

This is my metric sheet

My formular for Quoting:

=COUNTIFS({Order Tracker Template Range 2}, @cell = [Primary Column]@row, {Order Tracker Template Range 1}, @cell = "New Circuit")

kowal

hi @ejacksonBPT

When you are creating the graph (or pie chart)

Mark only those 4 lines

Quoting 0

In Progress 1

Completed 4

Cancelled 1

do not mark the line with cell: new circuits

it should show you 4 different colours on your graph (or 3 actually as quoting is 0)

Hope it helps.