Hi
I'm trying to show two colours on a chart where the data is from the same series but have different float levels. The attached chart shows how a float value of 0 should show red, and another value should show green.
Any help much appreciated.
Hi
I'm trying to show two colours on a chart where the data is from the same series but have different float levels. The attached chart shows how a float value of 0 should show red, and another value should show green.
Any help much appreciated.
You can do this by parceling out the items into different series using if statements.
This article goes into it in great detail with screenshots. https://peltiertech.com/conditional-...-excel-charts/
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks