That is how I want it too look, but how did you get the colours to change?? I've tried everything!
That is how I want it too look, but how did you get the colours to change?? I've tried everything!
You have to manually format the 3 different series to get red/orange/green.
But once the columns have been formatted the formula is controlling which 1 of the 3 data points is shown for each category. In the cells where #N/A is displayed the column of the chart is zero and therefore not visible.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks