Excel Mini Charts - BETTER than Sparklines!

[@andylea5314]

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.

[@MyOnlineTrainingHub]

Glad you like them! 😊

[@zandarrthegreat6790]

I came here to learn one thing (mini charts) and learned a whole lot more! Good video!

[@MyOnlineTrainingHub]

Fantastic to hear that :-)

[@EPMeokazi]

Loved the video! I had no idea F4 did that with special pasting!

[@dougdevine27]

That snap-to-cell alt trick...brilliant!

[@leonardbekker1524]

Brilliant! Just used this on a dashboard I was working on! It really made the data pop out at a glance!

[@MyOnlineTrainingHub]

Awesome to hear, Leonard!

[@Barhomopolis]

Thank you!! Never knew about Alt-dragging! ♥️

[@MyOnlineTrainingHub]

Great to know you discovered something new :-)

[@rrrprogram8667]

One of the best channels on excel.... Thanks for sharing the knowledge

[@MyOnlineTrainingHub]

Thanks for your kind words!

[@c.s.m.k5737]

My goodness, am learning so much from simple examples! 👍

[@MyOnlineTrainingHub]

Great to hear!

[@SonofthewindsInc]

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!

[@MyOnlineTrainingHub]

So glad you can make use of the mini-charts!

[@felipe4181]

Excellent tip to maximize the space in a dashboard!

[@MyOnlineTrainingHub]

Glad it was helpful!

[@nurmohammedmunshi4894]

All videos are very lovey & most informative. Thank you mam.

[@MyOnlineTrainingHub]

Thanks so much 😊

[@louisd95714]

I love your videos Mynda. Your Excel knowledge truly amazes me!

[@MyOnlineTrainingHub]

Thank you so much, Louis!

[@louisd95714]

@@MyOnlineTrainingHub You just got a new subscriber :)

[@ernstgenzs7456]

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😕

[@MyOnlineTrainingHub]

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.

[@kiwikiow]

I like mini charts and many useful tips. Thank you :)

[@bimmerboytripp249]

you are so cooool i love learning excel from you

[@MyOnlineTrainingHub]

Thank you so much! 😃

[@davidmmcmillan7214]

Came across your videos today and you make it easy to digest while being very informative. Thank you!

[@MyOnlineTrainingHub]

Glad you like them, David!

[@russguppy8761]

You are brilliant. Good job kid.

[@MyOnlineTrainingHub]

Thanks so much :-)

[@tomfontanella6585]

Like others, I found so many helpful tips in this. I now see that the ALT key should be my friend.

[@MyOnlineTrainingHub]

Glad you enjoyed it, Tom!

[@derekpage8924]

Happy New Year Mynda, Very nice. Keep them coming!

[@simonmassen]

love this, just built it into my Dashboard. Thank you V much

[@MyOnlineTrainingHub]

Great to hear, Simon!

[@tranhanh5663]

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

[@MyOnlineTrainingHub]

Indeed, Sparklines are great too, but the idea of this is to provide more functionality than Sparklines offer.

[@alchemistdreams]

This is so cool! Useful and yet not well known that you can do this.

[@MyOnlineTrainingHub]

Glad you’ll be able to make use of it 😊

[@bravucod]

Love your videos. Thanks for posting content more regularly!

[@komanguy]

Fantastic tips! Thanks a lot.

[@MyOnlineTrainingHub]

Glad it was helpful!

[@wayneedmondson1065]

Hi Mynda.. Happy New Year! Thanks for kicking it off with these interesting mini-charts.. very clever. Thanks for the tips and Thumbs up!

[@cjsalim]

thank you for your video supports, i like this channel so much

[@MyOnlineTrainingHub]

So nice of you :-) Please share it with your friends!

[@makisalimhussain2334]

Amazing video, thank you Mynda

[@shadrackawunyo7786]

Very beautifully done

[@wernerkallmann9105]

Excellent. Very helpful.

[@MyOnlineTrainingHub]

Glad to hear it!

[@belowzer00]

Very nice! You just taught me a few little tricks I didn't know, thank you!

[@MyOnlineTrainingHub]

Which was your favourite trick?

[@belowzer00]

@@MyOnlineTrainingHub The duplicate shortcut and snapping the charts to the cell like you did were new to me.

[@rockqwerty4187]

Amazing tutorial Munda🙏🙏

[@MyOnlineTrainingHub]

Glad you think so!

[@Chromosome11]

Impresed every viewer with your skills :-O

[@MyOnlineTrainingHub]

Thank you very much!

[@bratsummer1980]

I have become fan of you Excellent Two technologies F4 and alt dragging

[@MyOnlineTrainingHub]

Great to know you discovered a couple of tips you can use :-)

[@darrylmorgan]

Excellent,Really Helpful Tutorial!Thank You Mynda :):)

[@rxsybz]

Great , learned something new.

[@MyOnlineTrainingHub]

Awesome to hear!

[@davidtarvin8858]

Mind Blown.

[@MyOnlineTrainingHub]

:-) glad you enjoyed it, David!

[@alanhill5337]

Great explanation. TQ

[@MyOnlineTrainingHub]

Glad you found it helpful, Alan!

[@sylviakatabaazi3767]

Amazing! Thank you for sharing!

[@MyOnlineTrainingHub]

Glad you enjoyed it, Sylvia!

[@cortinas54]

great trick! thanks for sharing your knowledge

[@agnibhoos7834]

Amazing tutorial. I wish I could have downloaded the workbook. It seems the website is down at present.

[@MyOnlineTrainingHub]

Website isn't down. Please check again.

[@domingopedernera1038]

Thanks! You are awesome explaining, great tricks...

[@MyOnlineTrainingHub]

Glad you think so, Domingo :-)

[@ajinkyanaik6651]

Nice video..easy to understand....

[@sheaqe10]

love your videos. super useful.

[@MyOnlineTrainingHub]

Thanks so much, Rich!

[@rdatta]

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.

[@MyOnlineTrainingHub]

Thanks, Rajan! Good point on the colours :-)

[@k364k364]

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.

[@ashleigh3021]

It’s about 5-6% of people, not even close to 20%. Complete nonsense.

[@two_stones]

excellent training. thx.

[@JM-pf2uj]

Thank you so much for this video

[@edwardchau5818]

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?

[@MyOnlineTrainingHub]

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

[@ggalaso]

Very useful. Thank you!

[@MyOnlineTrainingHub]

Glad to hear that!

[@markanderson8066]

I learned a few things again! thank you!

[@MyOnlineTrainingHub]

Great to know it was helpful, Mark :-)

[@Luciano_mp]

Very cool, a good alternative. Thank you.

[@bedoborodolai8986]

Thank you Brilliant video

[@MyOnlineTrainingHub]

Glad you enjoyed it :-)

[@saravanansingaram3023]

Thank you!

[@MyOnlineTrainingHub]

Glad you liked it!

[@MirFayaz]

Amazing and informative video

[@MyOnlineTrainingHub]

Glad you enjoyed it 😊

[@comfy-life-always]

Thank you so much :)

[@MyOnlineTrainingHub]

You're welcome!

[@PardesiSpot]

Thanks madam pls always make short videos for us instead of long Video

[@MyOnlineTrainingHub]

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 :-)

[@youcefmeb8487]

Bonjour et merci pour tes vidéos trop cool

[@nasserghalandar5699]

thank u so much, it was useful to me

[@MyOnlineTrainingHub]

You're welcome, Ramin!

[@davidalejandrogutierrezgra7376]

I do love your videos, there y are so useful. Thanks :)

[@MyOnlineTrainingHub]

Thanks, David!

[@tarzansu1820]

Nice video tutorial. thank you

[@MyOnlineTrainingHub]

Thank you :-) Glad you liked the mini charts.

[@christopherwolf2002]

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.

[@MyOnlineTrainingHub]

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 ;-)

[@Chrisbajs]

How cute! And useful. Great tutor.

[@MyOnlineTrainingHub]

Glad you liked them :-)

[@ftskia6537]

Awesome video! Is it possible to do the same mini charts using a pivot table?

[@MyOnlineTrainingHub]

Thank you! Yes, you can do this with Pivot Charts.

[@ed4k]

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? :)

[@MyOnlineTrainingHub]

Thank you :-) Glad you discovered some useful tips!

[@kingroc3651]

Thank you! Before watching your videos I spent one hour to draw the trend chart for 30 lines of data. 😞

[@MyOnlineTrainingHub]

Glad it helped!

[@hassanraza-vb5ss]

Thanks alot for this video :) just one question here. i want to show -ve figures as RED in the chart. is this possible?

[@MyOnlineTrainingHub]

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

[@hassanraza-vb5ss]

@@MyOnlineTrainingHub Thank you :)

[@hazemali382]

always great Mynda ♥

[@MyOnlineTrainingHub]

Thanks again, Hazem!

[@L1UCIFER]

Thanks!

[@MyOnlineTrainingHub]

Pleasure 😊

[@harshababu8321]

Awesome Mam

[@MyOnlineTrainingHub]

Thank you :-)

[@naahidul]

Thank you.

[@MyOnlineTrainingHub]

You're welcome!

[@yoannkouame3282]

another one ,you're the best

[@MyOnlineTrainingHub]

Glad you enjoyed it, Yoann :-)

[@Muhammadwaqas-bs3nl]

Hi, @2:05 I am not able to distribute vertically, could you please assist.

[@MyOnlineTrainingHub]

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.

[@mohammedaltaf4877]

Great job

[@MyOnlineTrainingHub]

Thanks, Mohammed :-) Please share it with your co-workers. Mynda

[@Heavieth]

Amazing, once again.

[@MyOnlineTrainingHub]

Thanks again :-)

[@taaatooo]

Brilliant!1 Awsome!! Thank you very much!! ♥

[@MyOnlineTrainingHub]

Glad you like it!

[@bartoni79]

Can you create bar charts or stack charts to show green and red detailing actual vs budget YTD?

[@MyOnlineTrainingHub]

Yes 😊

[@KiwiSteveYT]

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?

[@MyOnlineTrainingHub]

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.

[@idlezebb]

Marvelous!...You are a goddess, thank you so much!

[@MyOnlineTrainingHub]

You're so welcome!

[@Muuip]

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!

[@MyOnlineTrainingHub]

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.

[@Muuip]

@@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 😊

[@pkal863]

thank you..

[@MyOnlineTrainingHub]

You're most welcome, Pkal!

[@jnhnmk]

Can you help how to compere program language evolution using excel chart please

[@MyOnlineTrainingHub]

Not sure what you mean, sorry.

[@jnhnmk]

@@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.

[@MyOnlineTrainingHub]

I don't have any data on this, sorry.

[@jnhnmk]

@@MyOnlineTrainingHub okay thank you

[@shakiraasfoor7599]

Well Done

[@MyOnlineTrainingHub]

Cheers, Shakira!

[@youngsunchoi4541]

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]

Distribute vertically works with any object, but you need 3 or more objects selected for the 'distribute' options to be available.

[@youngsunchoi4541]

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?

[@udaracperera]

Love it thanks alot

[@MyOnlineTrainingHub]

I'm glad you like it :-)

[@work4development]

Nice, but do I need to add the ghost series one by one of them?

[@work4development]

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

[@MyOnlineTrainingHub]

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.

[@miguelpallango7248]

Just awesomely …

[@MyOnlineTrainingHub]

Thank you so much 😀

[@Trucpq]

Excelent !

[@MyOnlineTrainingHub]

Thank you!

[@guillermofloresl.357]

Awesome!

[@silentingenuity2583]

You're amazing!

[@alexrosen8762]

Very useful! Thanks :-)

[@MyOnlineTrainingHub]

Cheers, Alex :-) Glad you'll be able to use them. Mynda

[@estivisonmc]

Muuuuuito bom! 👏👏👏👏

[@MyOnlineTrainingHub]

Obrigado :-)

[@definitelynosebreather]

@@MyOnlineTrainingHub What? 'o' Do you speak portuguese?

[@jeffreypritchard6102]

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?

[@MyOnlineTrainingHub]

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.

[@gdemerkl]

Nice !

[@MyOnlineTrainingHub]

Hope you can use the Mini Charts :-)

[@AA-qw2pm]

go on /////from yemen ..................that's great

[@robertalavezzari6970]

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

[@MyOnlineTrainingHub]

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

[@amtimbs]

Awesome

[@MyOnlineTrainingHub]

Thanks so much :-)

[@vinay94095]

Is it done on Power BI excel?

[@MyOnlineTrainingHub]

This is Excel :-)

[@ser1can01]

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:)))

[@MyOnlineTrainingHub]

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.

[@jimfitch]

Brilliant! Thanks!

[@geisamendes5887]

👏👏👏👏

[@MyOnlineTrainingHub]

🙏

[@bloggermanpreet]

👌👌👌

[@MyOnlineTrainingHub]

Glad you liked it :-)