Notifications
Clear all
Topic starter
Creating a Column chart with multiple color columns based this requirement: Green (50.0 hrs or above), Yellow (49.9 -0.0), and Red (Negative numbers). I also, what a diagonal Line from Upper Left corner to the Lower Right corner. Lastly columns shorted highest-to-lowest.
Attached is a sample source and a file with current format. Example of similar format that I'm trying to achieve.
Posted : 21/01/2019 9:36 pm
Hi Hasan
To create the 3 colors, you will need to separate the hours into 3 different columns.
You will need to sort your source data by hours. For the diagonal line, I suggest you draw it manually.
Sunny
Posted : 23/01/2019 12:31 am