5 Dashboard Design Tips - COMMON MISTAKES to avoid! - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 8
BROWNBROWS
Hi, I don-t think I-ve seen you cover what I experienced recently. I was saw a pivot table with a slightly duplicate Field Name that did not appear in the table . For example CookiesJar and CookieJar2 were both field names but CookiesJar2 was not in the table. I realized the person used Group Selection on CookieJar then named Group2 CookieJar2. I also realized this was great until I added more data to the table and notice some data in CJ2 now needed to be in CJ. I hope my description is clear. If so, is there a way to add and remove data from the grouping selection without affecting previous grouping? (Not dates it regular text data)
reply
Hi, I don-t think I-ve seen you cover what I experienced recently. I was saw a pivot table with a slightly duplicate Field Name that did not appear in the table . For example CookiesJar and CookieJar2 were both field names but CookiesJar2 was not in the table. I realized the person used Group Selection on CookieJar then named Group2 CookieJar2. I also realized this was great until I added more data to the table and notice some data in CJ2 now needed to be in CJ. I hope my description is clear. If so, is there a way to add and remove data from the grouping selection without affecting previous grouping? (Not dates it regular text data)
reply
Simon
great stuff as ever, thank you. I'm wondering is the a way to get excel to generate an automated email if a certain criteria is reached. For instance my Workplan counts down days until a deadline is reached, I have it set to change to Red when a deadline is reached but would be interested if there is a way of generating a email (or a calendar item)? Don't know if either of these are possible but if it is thought you may know. Simon
reply
great stuff as ever, thank you. I'm wondering is the a way to get excel to generate an automated email if a certain criteria is reached. For instance my Workplan counts down days until a deadline is reached, I have it set to change to Red when a deadline is reached but would be interested if there is a way of generating a email (or a calendar item)? Don't know if either of these are possible but if it is thought you may know. Simon
reply
big1975E
Great video! Very helpful!! Do you by chance have a dashboard design class?? Something that goes more in-depth on the rules or guidelines around design, functionality (when to use slicers vs data validation lists vs VBA), number of kpi to include, choosing a color scheme, advanced functionality like drill through and/or hyperlinks.
reply
Great video! Very helpful!! Do you by chance have a dashboard design class?? Something that goes more in-depth on the rules or guidelines around design, functionality (when to use slicers vs data validation lists vs VBA), number of kpi to include, choosing a color scheme, advanced functionality like drill through and/or hyperlinks.
reply
Scott
hii.
Love your work :)
Quick question, is there a way of formatting a cell colour based on to cells with the same value, example.. if E4 and F4 both 'PASS' then A4 will conditional format to green colour.?
I have tried many ways but i cannot seem to get it working :/
Thanks In advance
reply
hii.
Love your work :)
Quick question, is there a way of formatting a cell colour based on to cells with the same value, example.. if E4 and F4 both 'PASS' then A4 will conditional format to green colour.?
I have tried many ways but i cannot seem to get it working :/
Thanks In advance
reply
Yednek
hi dear , thanks for ur inspiring video. i have a problem of inserting text into a text box by linking formula . half of the text get cut due to character limit.....is there any method to pass this character limit in text box ?
reply
hi dear , thanks for ur inspiring video. i have a problem of inserting text into a text box by linking formula . half of the text get cut due to character limit.....is there any method to pass this character limit in text box ?
reply
John
Thank you. Another great video. I personally like a softer white on the charts and a light grey for any padding. Do you have any feedback on a softer white than the white which was displayed on the dashboard in your video.
reply
Thank you. Another great video. I personally like a softer white on the charts and a light grey for any padding. Do you have any feedback on a softer white than the white which was displayed on the dashboard in your video.
reply
Billiam
Definitely helpful tips as ever, but I would say that the white background and bright text is hard to look at for me.
I much prefer a darker background if using white or pale text. (not sure if that's just me!?)
reply
Definitely helpful tips as ever, but I would say that the white background and bright text is hard to look at for me.
I much prefer a darker background if using white or pale text. (not sure if that's just me!?)
reply
baphnie
The dashboard still seems too bright for my taste. Is darker generally better, or does that make choosing a color scheme more difficult?
reply
The dashboard still seems too bright for my taste. Is darker generally better, or does that make choosing a color scheme more difficult?
reply
Add a review, comment
Other channel videos
