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!
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
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.
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
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.
@@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.
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.
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? :)
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 😊
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?
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 ;-)
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 :-)
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.
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
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.
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.
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! 😊
I came here to learn one thing (mini charts) and learned a whole lot more! Good video!
Fantastic to hear that :-)
Loved the video! I had no idea F4 did that with special pasting!
One of the best channels on excel.... Thanks for sharing the knowledge
Thanks for your kind words!
That snap-to-cell alt trick...brilliant!
My goodness, am learning so much from simple examples! 👍
Great to hear!
Thank you!! Never knew about Alt-dragging! ♥️
Great to know you discovered something new :-)
All videos are very lovey & most informative. Thank you mam.
Thanks so much 😊
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!
I love your videos Mynda. Your Excel knowledge truly amazes me!
Thank you so much, Louis!
@@MyOnlineTrainingHub You just got a new subscriber :)
Excellent tip to maximize the space in a dashboard!
Glad it was helpful!
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!
Fantastic tips! Thanks a lot.
Glad it was helpful!
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 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.
thank you for your video supports, i like this channel so much
So nice of you :-) Please share it with your friends!
Can you create bar charts or stack charts to show green and red detailing actual vs budget YTD?
Yes 😊
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!
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 :)
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 😊
I like mini charts and many useful tips. Thank you :)
Happy New Year Mynda, Very nice. Keep them coming!
Amazing tutorial Munda🙏🙏
Glad you think so!
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.
you are so cooool i love learning excel from you
Thank you so much! 😃
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.
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
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.
You are brilliant.
Good job kid.
Thanks so much :-)
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, @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.
Hi Mynda.. Happy New Year! Thanks for kicking it off with these interesting mini-charts.. very clever. Thanks for the tips and Thumbs up!
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.
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
Excellent. Very helpful.
Glad to hear it!
Great explanation. TQ
Glad you found it helpful, Alan!
Love your videos. Thanks for posting content more regularly!
Amazing! Thank you for sharing!
Glad you enjoyed it, Sylvia!
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.
Impresed every viewer with your skills :-O
Thank you very much!
Amazing video, thank you Mynda
thank u so much, it was useful to me
You're welcome, Ramin!
Thanks! You are awesome explaining, great tricks...
Glad you think so, Domingo :-)
Mind Blown.
:-) glad you enjoyed it, David!
always great Mynda ♥
Thanks again, Hazem!
love your videos. super useful.
Thanks so much, Rich!
Thank you! Before watching your videos I spent one hour to draw the trend chart for 30 lines of data. 😞
Glad it helped!
great trick! thanks for sharing your knowledge
Very beautifully done
Excellent,Really Helpful Tutorial!Thank You Mynda :):)
I do love your videos, there
y are so useful. Thanks :)
Thanks, David!
Thank you Brilliant video
Glad you enjoyed it :-)
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!
Amazing and informative video
Glad you enjoyed it 😊
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 😊
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?
Nice video tutorial. thank you
Thank you :-) Glad you liked the mini charts.
Very useful. Thank you!
Glad to hear that!
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 ;-)
Thank you!
Glad you liked it!
Nice video..easy to understand....
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 :-)
excellent training. thx.
Thank you so much :)
You're welcome!
Thank you so much for this video
I learned a few things again! thank you!
Great to know it was helpful, Mark :-)
Bonjour et merci pour tes vidéos trop cool
Awesome Mam
Thank you :-)
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 :-)
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.
Very cool, a good alternative. Thank you.
Great , learned something new.
Awesome to hear!
Is it done on Power BI excel?
This is Excel :-)
another one ,you're the best
Glad you enjoyed it, Yoann :-)
Thanks!
Pleasure 😊
How cute! And useful. Great tutor.
Glad you liked them :-)
Brilliant!1 Awsome!! Thank you very much!! ♥
Glad you like it!
Thank you.
You're welcome!
thank you..
You're most welcome, Pkal!
Great job
Thanks, Mohammed :-) Please share it with your co-workers. Mynda
Marvelous!...You are a goddess, thank you so much!
You're so welcome!
Love it thanks alot
I'm glad you like it :-)
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.
Well Done
Cheers, Shakira!
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
Excelent !
Thank you!
Amazing, once again.
Thanks again :-)
Muuuuuito bom! 👏👏👏👏
Obrigado :-)
@@MyOnlineTrainingHub What? 'o' Do you speak portuguese?
Nice !
Hope you can use the Mini Charts :-)
Very useful! Thanks :-)
Cheers, Alex :-) Glad you'll be able to use them. Mynda
Awesome!
Just awesomely …
Thank you so much 😀
You're amazing!
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.
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.
Awesome
Thanks so much :-)
go on /////from yemen ..................that's great
There should be a macro for this
Great idea. I'm sure you could write one, Hans :-)
Brilliant! Thanks!