My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Project Management Dashboard Conditional Formatting for Monthly |Dashboards & Charts|Excel Forum|My Online Training Hub

You are here: Home / Project Management Dashboard Conditional Formatting for Monthly |Dashboards & Charts|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Project Management Dashboard Conditional Formatting for Monthly
Avatar
Taza Tarwala

New Member
Members
Level 0
Forum Posts: 1
Member Since:
April 17, 2024
sp_UserOfflineSmall Offline
1
April 17, 2024 - 3:54 pm
sp_Permalink sp_Print sp_EditHistory

Hi team, 

Thank you so much for the helpful video on creating the project management dashboard. 

I have also seen your video on adding Excel Project Management Dashboard with Dynamic Periods. 

The conditional formatting is not showing correctly as the shaded portions in Gantt is going after the end date, esp for the completed tasks. 

The sort order for the project on the Dashboard tab is different to the project order I have on the data tab and I cannot seem to replicate it on the Dashboard tab. 

I have attached the sample excel, can you please help me? 

Avatar
Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members

Moderators
Level 1
Forum Posts: 1047
Member Since:
January 31, 2022
sp_UserOfflineSmall Offline
2
April 18, 2024 - 2:59 pm
sp_Permalink sp_Print

No file attached. Please try again. This time, press the 'Start upload' button and wait for it to finish before you press 'Submit Reply'.

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 925
Purfleet: 415
Frans Visser: 349
Hans Hallebeek: 343
David_Ng: 312
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
WdwwPuKkx YjFmsfPYXpBW
Lisa Donaldson
roiAIAGUodrbOHw aCBaBxTfphIXDhr
Hiroyuki Murai
Mark Allen
Yves Gagnon
PATRICK WALTER
Carley Brice
Ash Rahman
Christelle Lamprecht
Forum Stats:
Groups: 3
Forums: 25
Topics: 7088
Posts: 31065

 

Member Stats:
Guest Posters: 49
Members: 34506
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen