Search results

Hi guys, I have a macro that automatically updates my doughnut chart colours to the original data cell colour. However, I have now inserted a conditional formatting to the original data cell which renders this macro unusable now. Please help! Example, when users select the project progress in...

Hi Narayan, Thank you this is exactly how I wanted it to work!! How did you do this? The normal way to hyperlink does no enables a hidden sheet to pop out and hides back again like what your sheet does. Is there a special macro for it? Where do I find it? If you could list the steps you went...

Hi Narayan, Thank you so much for your assistance! I have decided to just put a text box in front of the opeque white bars and rearrange so as the linked cells are not blocked by it. Thank youuu! Still facing one more issue on hyperlinks that I have posted here if you could advise. Thank you!

Hi guys, I have a simple dashboard with four worksheet tabs. The first tab is the dashboard with many different charts that I would like to link to many different tables in two hidden sheets. I would like to have from the Dashboard, all the individual project doughnut charts linked to its...

Hi Narayan, Thank you for your reply. So sorry that this is super confusing. 1. Yes, correct. 2. These legends are for all charts and the whole dashboard. So, say a project in Planned Project List is Delayed, users will manually changed it to yellow in the Planned Project List tab (as per...

Hi Narayan, Thank you for your reply. Sorry my bad, yes its a macro. Please refer to the attached. Please see Tab Scratchpad first and then Dashboard as I wrote up a note to explain there. I'm doing up a simple dashboard and would like to have the chart colours automatically reflected to...

Hmm, I see....thanks Luke M and KenU!

Hi guys, So, I have found this formula that automatically changes chart colours depending on the original data cell colour. However, I am facing a problem when the original data cell colour is set to "no fill" the chart bar still comes out as a solid opeque "white". In my intended use, it is...

Hi guys! I'm new here...looking for advise on how can I link a cell colour onto another cell and have the second cell's colour automatically updates whenever the first cell colour is changed manually. Example SHEET 1 cell A1 is set as GREY for the background colour. I want to link it to SHEET...