Graduated colouring on bar graph

Dropdeadhomer

New Member
Joined
Oct 8, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I am trying to create a graph where the vertical axis is a list of projects (project a, project b etc) and the horizontal axis is a series of months (jan-dec).
I would then like to have a bar for each of the projects that runs horizontally for each project depending on the months that work will be happening (eg project A has a bar from jan to mar, project B jan-sept etc)
What I would then like to be able to do is to cross ref each month against a separate “impact” score and colour code the bat accordingly.
So, for example Project A is building from Jan to Oct, so it has a horizontal bar from Jan to Oct. The impact of this is (on a 1-8 score with one being low/green and 8 being high:red) a 2 in jan, a 4 in feb, a 7 in mar and apr, a 5 in may, June,July an 8 in August, a 4 in sept and a 2 in Oct.
is there anyway that the horizontal bar from jan thru to Oct can be colour coded linked to the impact score?
If so, it would have to be code-free as this would be used for a work slide and coding not allowed.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Not sure how to do that in a chart. Can do something similar with conditional formatting:

Book2 (version 2).xlsb.xlsm
ABCDEFGHIJKLMNO
1StartEndProjectJanFebMarAprMayJunJulAugSepOctNovDec
2JanuaryOctoberProject12477555842
3FebruaryAugustProject22435633
4MarchJulyProject312624
5AprilNovemberProject481565373
6MayDecemberProject572148882
7AugustOctoberProject6348
8JulyDecemberProject7113286
9AugustNovemberProject87414
Sheet4
Cells with Conditional Formatting
CellConditionCell FormatStop If True
D2:O9Other TypeColor scaleNO
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top