Excel Forum • My Online Training Hub

Interactive Excel Project Management Dashboard

Sebahattin Keskin

New Member

Members

Forum Posts: 2

Member Since:
January 24, 2023

Offline

January 24, 2023 - 6:37 pm

Hey everyone,

i recreated the Project Management Dashboard from the Video Mynda made on Youtube.

I just wanted to know, if its possible to change the color of the time bars based on the Project. Like individuell color for each project.

I am looking forward to read your reply. Laugh

Mynda Treacy

Admin

Forum Posts: 4352

Member Since:
July 16, 2010

Offline

January 25, 2023 - 9:27 pm

Hi Sebahattin,

Yes, you can add more conditional formats (one for each project) that colours the cells, but if you have a lot of projects, then it's a lot of work!

If you get stuck, please share your file here and we can see where you've gone wrong and help further.

Mynda

Sebahattin Keskin

New Member

Members

Forum Posts: 2

Member Since:
January 24, 2023

Offline

January 25, 2023 - 10:31 pm

Hi Mynda,

here is the file i am working with. It's in german, but Project is equal to Maschine, Startzeit = Start Time, Endzeit = End Time.

I hope you can handle it with german 😀

Sebahattin

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 170

Currently Online: Riny van Eekelen, Ivan Kulubya, Christian Huapaya

Guest(s) 29

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1431

Anders Sehlstedt: 845

Velouria: 574

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 213

A.Maurizio: 202

Aye Mu: 201

Jessica Stewart: 185

Newest Members:

Vicky Otosnika

Abhishek Singh

Kevin Sojourner

Kara Weiss

And Woox

Armani Quenga

moshood bello

annelies b

James1989

lucy gilmour

Forum Stats:

Groups: 3

Forums: 24

Topics: 6045

Posts: 26523

Member Stats:

Guest Posters: 49

Members: 31492

Moderators: 2

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Riny van Eekelen