Forum

Notifications
Clear all

Create Column Chart with multiple colors and diagonal reference line

2 Posts
2 Users
0 Reactions
95 Views
(@cfhasan1)
Posts: 1
New Member
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
(@sunnykow)
Posts: 1417
Noble Member
 

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
Share: