Oh MY Life ! I learnt so many new tricks here! I so wished I had come across these sessions - 5-10 years ago. I would have saved my self a whole lot of time AND produced much better quality work. Thank you so much for sharing.
This is very useful indeed. A sort of mini financial dash board. Experimented using your ideas where all the top line info , the Dimensions in rows .. Budget V Actuals and all the monthlies . Between the top lines and tables are 4 doughnut progress circles. Love it!
Thanks, Edward! I don't use a Mac, sorry. My limited knowledge understanding is that CMD is the equivalent of CTRL, but otherwise I'm not sure. You might find this keyboard cover useful: www.myonlinetraininghub.com/mac-excel-keyboard-shortcuts-cover
Well done! Again. Some really interesting ideas. A couple of design pointers a) 20% or so of the general population has some form of colour recognition disability. The most common is Red-Green colour blindness. Please urge your audience to use colour palettes that accommodate such constraints. Never use Red/Green in such proximity. b) I would think for mini-charts choosing high contrast colour combinations would be very valuable given the compressed space.
I have Deuteranomaly which is the most common type of red-green colour blindness. I find that light-green against dark-red is ok, as is dark-green against light-red. But not both dark or both light.
F4. is it sad that F4 was my Favorite thing from this whole video. Thanks. keep doing great things. I wish there were ways around macro's as my company does not allow them in excel. Made me move to doing more stuff in access to get certain data and then link it back to the excel or a new excel file.
Great to hear you discovered some tips you can use. I wouldn't worry too much about macros. There is a huge amount you can do with Power Query to automate the getting and cleaning of data and it's much quicker and easier to learn. You can find out more about what Power Query can do here on my course page: www.myonlinetraininghub.com/excel-power-query-course No pressure to join ;-)
In the chart...they're a bit small to show numbers in the chart. If you mean in the table of numbers, then you can use a custom number format to format negative values red: www.myonlinetraininghub.com/excel-custom-number-format-guide#_Toc474757765
Love your videos and hairstyle! Didnt know about alt-dragging, F4 and you can align vertically in between two charts till today! Just a feedback: do you think your logo (MyOnlineTrainingHub) in your spreadsheet needs some transparency love? :)
Hi , Greetings from New Zealand :) I'm so enjoying your great explanations :) I see you say Variance when, as a mathematician, I'd say Difference. We say Variance is the square of the Standard Deviation. Am I being fussy, or what?
Hi Stephen, It's great to hear you're enjoying my videos. As an accountant we say Variance when something is different to what we expect :-) it's a variance to the budgeted amount, or the budget has been varied to arrive at the actual amount.
Great presentation! F4 is a great tip to work around Excel auto default formatting 👍 Do you have a video on how to permanently set chart formatting in a dashboard with interactive data? (4-charts Dashboard from Power Pivot) Many Thanks!
I presume you're referring to the problem where the formatting changes as you select a different item in the Slicer. If so, you need to clear all filters from the chart/Slicer, then set the formatting. That way you are formatting each series and when they are selected in the Slicer the formatting you applied will be displayed in the chart.
@@MyOnlineTrainingHub Exactly! Problem arise when I use multiple slicers in my dashboard, default chart formatting comes back. I will format my charts before creating the slicers next time. Thank you so much 😊
I let the video length be dictated by the topic. I'd rather produce something that is useful than stick to a time limit. Sometimes that means my videos are long, like dashboards :-)
You could have taught how to make the series compatible... hard without it. Follow through this point. But stuck there, many line charts I have, to add a ghost series one by one is a pain
If you create the first chart with the ghost series you can just copy the chart and then point it at the new dataset while the ghost series stays in tact.
It is really useful video. I tried to follow your instructions but for me "Distribute Vertically" does not work. I assume this has something to do with mini chart size?
MyOnlineTrainingHub Actually, it is not “Distribute vertocally” problem. I think I have a problem with sizing a graph to fill in a cell with “Alt” key. Somehow i am not able to make a graph to fit a cell. Do you have any video that shows how to do this?
@@MyOnlineTrainingHub I have a research assignment and need to use Word and Excel but my research about why people think coding is hard! so I don't know how to do with Excel-like: what information to use it and compare can you give me some idea? Please I know we can use Excel for the number of tax year income but for my topic, I don't know.
Thak you for this...but on the budget chart there is a someting unlogical...actual values bigger than budget is green colour.actual values smaller than budget is red colour:)))
If you're tracking sales values and actual is less than budget, then this is an adverse variance hence the red colour. If sales exceed budget then this is a positive variance, hence the green colour.
Hello. I have sparklines that show the daily yield curve for U.S. notes and bonds. This data goes all the way back to 1990. Is there a way to animate these sparklines into some kind of slide show or video? I would like to show one sparkline at a time in rapid succession to show changes. There are nearly 8,000 sparkline graphs that I would need to display. Any advice?
Hi Roberta, I don't know the Italian shortcuts, sorry. In the video you see that I left click and drag the range being referenced in the chart, I suspect you're adding them some other way if they're being added. If you're still stuck, please post your question and sample file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
Not sure why you wouldn't be able to distribute vertically. The key is to have the charts at the top and bottom of the range in the positions you want, and then select all charts before distributing vertically.
See Home tab > Conditional Formatting > Icon Sets > Ratings group. This will give you fractions in quarter increments. Of course you can do a mini chart as a pie chart, but it'll probably be difficult to read.
![Twenty One Pilots - The Line (from Arcane Season 2) [Official Audio]](http://i.ytimg.com/vi/XCz7WUotXs8/mqdefault.jpg)
Oh MY Life ! I learnt so many new tricks here! I so wished I had come across these sessions - 5-10 years ago. I would have saved my self a whole lot of time AND produced much better quality work. Thank you so much for sharing.
Glad you like them! 😊
Loved the video! I had no idea F4 did that with special pasting!
I came here to learn one thing (mini charts) and learned a whole lot more! Good video!
Fantastic to hear that :-)
Thank you!! Never knew about Alt-dragging! ♥️
Great to know you discovered something new :-)
That snap-to-cell alt trick...brilliant!
Brilliant! Just used this on a dashboard I was working on! It really made the data pop out at a glance!
Awesome to hear, Leonard!
One of the best channels on excel.... Thanks for sharing the knowledge
Thanks for your kind words!
My goodness, am learning so much from simple examples! 👍
Great to hear!
This is very useful indeed. A sort of mini financial dash board. Experimented using your ideas where all the top line info , the Dimensions in rows .. Budget V Actuals and all the monthlies . Between the top lines and tables are 4 doughnut progress circles. Love it!
So glad you can make use of the mini-charts!
Great, informative video....AND you have the BEST accent! I could listen to you for hours!
Wow, thanks!
Excellent tip to maximize the space in a dashboard!
Glad it was helpful!
All videos are very lovey & most informative. Thank you mam.
Thanks so much 😊
I had a presentation to make last week and to use this one. Thank you. Nonetheless my boss didn’t like it -they preferred the all spark lines😕
Can’t please em all, Ernst 😊 but seriously, if sparklines do the job then I’d use them too because they’re a lot easier to create.
Like others, I found so many helpful tips in this. I now see that the ALT key should be my friend.
Glad you enjoyed it, Tom!
I love your videos Mynda. Your Excel knowledge truly amazes me!
Thank you so much, Louis!
@@MyOnlineTrainingHub You just got a new subscriber :)
Came across your videos today and you make it easy to digest while being very informative. Thank you!
Glad you like them, David!
love this, just built it into my Dashboard. Thank you V much
Great to hear, Simon!
you are so cooool i love learning excel from you
Thank you so much! 😃
I like mini charts and many useful tips. Thank you :)
This is so cool! Useful and yet not well known that you can do this.
Glad you’ll be able to make use of it 😊
Fantastic tips! Thanks a lot.
Glad it was helpful!
Happy New Year Mynda, Very nice. Keep them coming!
thank you for your video supports, i like this channel so much
So nice of you :-) Please share it with your friends!
You are brilliant.
Good job kid.
Thanks so much :-)
Love your videos. Thanks for posting content more regularly!
Excellent. Very helpful.
Glad to hear it!
Very nice! You just taught me a few little tricks I didn't know, thank you!
Which was your favourite trick?
@@MyOnlineTrainingHub The duplicate shortcut and snapping the charts to the cell like you did were new to me.
If it's just a line or column, you can use the "sparklines" function in the insert tab with the same outcome but a bit faster
Indeed, Sparklines are great too, but the idea of this is to provide more functionality than Sparklines offer.
Hi Mynda.. Happy New Year! Thanks for kicking it off with these interesting mini-charts.. very clever. Thanks for the tips and Thumbs up!
Very beautifully done
Amazing video, thank you Mynda
I have become fan of you
Excellent
Two technologies
F4 and alt dragging
Great to know you discovered a couple of tips you can use :-)
Amazing tutorial. I wish I could have downloaded the workbook. It seems the website is down at present.
Website isn't down. Please check again.
Great video as always, Mynda. I notice that you use a lot of keyboard shortcuts that are applicable to Windows PC. Any thoughts on Macs?
Thanks, Edward! I don't use a Mac, sorry. My limited knowledge understanding is that CMD is the equivalent of CTRL, but otherwise I'm not sure. You might find this keyboard cover useful: www.myonlinetraininghub.com/mac-excel-keyboard-shortcuts-cover
Thanks! You are awesome explaining, great tricks...
Glad you think so, Domingo :-)
Great , learned something new.
Awesome to hear!
Amazing tutorial Munda🙏🙏
Glad you think so!
great trick! thanks for sharing your knowledge
Excellent,Really Helpful Tutorial!Thank You Mynda :):)
Amazing! Thank you for sharing!
Glad you enjoyed it, Sylvia!
Impresed every viewer with your skills :-O
Thank you very much!
Thank you! Before watching your videos I spent one hour to draw the trend chart for 30 lines of data. 😞
Glad it helped!
love your videos. super useful.
Thanks so much, Rich!
Mind Blown.
:-) glad you enjoyed it, David!
Great explanation. TQ
Glad you found it helpful, Alan!
Nice video..easy to understand....
Well done! Again. Some really interesting ideas. A couple of design pointers a) 20% or so of the general population has some form of colour recognition disability. The most common is Red-Green colour blindness. Please urge your audience to use colour palettes that accommodate such constraints. Never use Red/Green in such proximity. b) I would think for mini-charts choosing high contrast colour combinations would be very valuable given the compressed space.
Thanks, Rajan! Good point on the colours :-)
I have Deuteranomaly which is the most common type of red-green colour blindness. I find that light-green against dark-red is ok, as is dark-green against light-red. But not both dark or both light.
It’s about 5-6% of people, not even close to 20%. Complete nonsense.
I do love your videos, there
y are so useful. Thanks :)
Thanks, David!
Thank you so much for this video
I learned a few things again! thank you!
Great to know it was helpful, Mark :-)
F4. is it sad that F4 was my Favorite thing from this whole video. Thanks. keep doing great things. I wish there were ways around macro's as my company does not allow them in excel. Made me move to doing more stuff in access to get certain data and then link it back to the excel or a new excel file.
Great to hear you discovered some tips you can use. I wouldn't worry too much about macros. There is a huge amount you can do with Power Query to automate the getting and cleaning of data and it's much quicker and easier to learn. You can find out more about what Power Query can do here on my course page: www.myonlinetraininghub.com/excel-power-query-course No pressure to join ;-)
Very useful. Thank you!
Glad to hear that!
excellent training. thx.
Very cool, a good alternative. Thank you.
Can you create bar charts or stack charts to show green and red detailing actual vs budget YTD?
Yes 😊
Thanks alot for this video :) just one question here. i want to show -ve figures as RED in the chart. is this possible?
In the chart...they're a bit small to show numbers in the chart. If you mean in the table of numbers, then you can use a custom number format to format negative values red: www.myonlinetraininghub.com/excel-custom-number-format-guide#_Toc474757765
@@MyOnlineTrainingHub Thank you :)
Thank you Brilliant video
Glad you enjoyed it :-)
thank u so much, it was useful to me
You're welcome, Ramin!
Love your videos and hairstyle! Didnt know about alt-dragging, F4 and you can align vertically in between two charts till today! Just a feedback: do you think your logo (MyOnlineTrainingHub) in your spreadsheet needs some transparency love? :)
Thank you :-) Glad you discovered some useful tips!
Thank you!
Glad you liked it!
Hi , Greetings from New Zealand :)
I'm so enjoying your great explanations :)
I see you say Variance when, as a mathematician, I'd say Difference. We say Variance is the square of the Standard Deviation. Am I being fussy, or what?
Hi Stephen, It's great to hear you're enjoying my videos. As an accountant we say Variance when something is different to what we expect :-) it's a variance to the budgeted amount, or the budget has been varied to arrive at the actual amount.
always great Mynda ♥
Thanks again, Hazem!
How cute! And useful. Great tutor.
Glad you liked them :-)
Awesome video! Is it possible to do the same mini charts using a pivot table?
Thank you! Yes, you can do this with Pivot Charts.
Amazing and informative video
Glad you enjoyed it 😊
Bonjour et merci pour tes vidéos trop cool
Nice video tutorial. thank you
Thank you :-) Glad you liked the mini charts.
Great presentation!
F4 is a great tip to work around Excel auto default formatting 👍
Do you have a video on how to permanently set chart formatting in a dashboard with interactive data?
(4-charts Dashboard from Power Pivot)
Many Thanks!
I presume you're referring to the problem where the formatting changes as you select a different item in the Slicer. If so, you need to clear all filters from the chart/Slicer, then set the formatting. That way you are formatting each series and when they are selected in the Slicer the formatting you applied will be displayed in the chart.
@@MyOnlineTrainingHub Exactly! Problem arise when I use multiple slicers in my dashboard, default chart formatting comes back. I will format my charts before creating the slicers next time.
Thank you so much 😊
Thanks madam pls always make short videos for us instead of long Video
I let the video length be dictated by the topic. I'd rather produce something that is useful than stick to a time limit. Sometimes that means my videos are long, like dashboards :-)
Nice, but do I need to add the ghost series one by one of them?
You could have taught how to make the series compatible... hard without it. Follow through this point. But stuck there, many line charts I have, to add a ghost series one by one is a pain
If you create the first chart with the ghost series you can just copy the chart and then point it at the new dataset while the ghost series stays in tact.
Awesome Mam
Thank you :-)
It is really useful video. I tried to follow your instructions but for me "Distribute Vertically" does not work. I assume this has something to do with mini chart size?
Distribute vertically works with any object, but you need 3 or more objects selected for the 'distribute' options to be available.
MyOnlineTrainingHub Actually, it is not “Distribute vertocally” problem. I think I have a problem with sizing a graph to fill in a cell with “Alt” key. Somehow i am not able to make a graph to fit a cell. Do you have any video that shows how to do this?
Thanks!
Pleasure 😊
another one ,you're the best
Glad you enjoyed it, Yoann :-)
Brilliant!1 Awsome!! Thank you very much!! ♥
Glad you like it!
Marvelous!...You are a goddess, thank you so much!
You're so welcome!
Amazing, once again.
Thanks again :-)
Thank you.
You're welcome!
Can you help how to compere program language evolution using excel chart please
Not sure what you mean, sorry.
@@MyOnlineTrainingHub I have a research assignment and need to use Word and Excel but my research about why people think coding is hard! so I don't know how to do with Excel-like: what information to use it and compare can you give me some idea?
Please I know we can use Excel for the number of tax year income but for my topic, I don't know.
I don't have any data on this, sorry.
@@MyOnlineTrainingHub okay thank you
Great job
Thanks, Mohammed :-) Please share it with your co-workers. Mynda
Love it thanks alot
I'm glad you like it :-)
thank you..
You're most welcome, Pkal!
Very useful! Thanks :-)
Cheers, Alex :-) Glad you'll be able to use them. Mynda
Thak you for this...but on the budget chart there is a someting unlogical...actual values bigger than budget is green colour.actual values smaller than budget is red colour:)))
If you're tracking sales values and actual is less than budget, then this is an adverse variance hence the red colour. If sales exceed budget then this is a positive variance, hence the green colour.
Excelent !
Thank you!
You're amazing!
Awesome!
Well Done
Cheers, Shakira!
Hello. I have sparklines that show the daily yield curve for U.S. notes and bonds. This data goes all the way back to 1990. Is there a way to animate these sparklines into some kind of slide show or video? I would like to show one sparkline at a time in rapid succession to show changes. There are nearly 8,000 sparkline graphs that I would need to display. Any advice?
Hi Jeffrey, you'd have to write some VBA code to animate them the way you describe. I don't have any examples of it though.
Just awesomely …
Thank you so much 😀
Hallo I am in Italy, my ctrl + D does not work, also my series are not picked up but added to the main graph, how come? help
Hi Roberta, I don't know the Italian shortcuts, sorry. In the video you see that I left click and drag the range being referenced in the chart, I suspect you're adding them some other way if they're being added. If you're still stuck, please post your question and sample file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
Nice !
Hope you can use the Mini Charts :-)
Hi, @2:05 I am not able to distribute vertically, could you please assist.
Not sure why you wouldn't be able to distribute vertically. The key is to have the charts at the top and bottom of the range in the positions you want, and then select all charts before distributing vertically.
Muuuuuito bom! 👏👏👏👏
Obrigado :-)
@@MyOnlineTrainingHub What? 'o' Do you speak portuguese?
Is it done on Power BI excel?
This is Excel :-)
go on /////from yemen ..................that's great
Brilliant! Thanks!
Awesome
Thanks so much :-)
There should be a macro for this
Great idea. I'm sure you could write one, Hans :-)
how can I do a mini chart that is a 'pie-chart' ?
With conditional formatting.
@@MyOnlineTrainingHub can you provide an example or video showing how ?
See Home tab > Conditional Formatting > Icon Sets > Ratings group. This will give you fractions in quarter increments. Of course you can do a mini chart as a pie chart, but it'll probably be difficult to read.