Automate Colour Change of Percentage Data Bar

S

Sam Lam

New Member
Joined
Aug 17, 2023
Messages
6
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
Hi all, does anyone know how can I insert a second layer of colour onto my data bar at the back based on the percentage input? The first layer of colour indicates the amount of days needed for a project.
 

Attachments

  • 1692666643226.png
    1692666643226.png
    52.4 KB · Views: 22

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
You must log in or register to reply here.

Similar threads

M
  • Question Question
2 layer maps in Excel (or other software)
Replies
1
Views
139
sijpie
sijpie
SteveP29
  • Solved
Gloss Colours in A Stacked Bar Chart
Replies
2
Views
123
SteveP29
SteveP29
M
  • Question Question
Compare cell colour to other cell colour and trigger action automatically
Replies
7
Views
463
Maxime_Excel
M
A
  • Question Question
VBA to change cell colour based on content
Replies
3
Views
867
Snakehips
Snakehips
N
  • Question Question
save table data to query
Replies
1
Views
196
GraH
GraH

Forum statistics

Threads
1,224,823
Messages
6,181,182
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

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