Excel Mini Charts - BETTER than Sparklines!
HTML-код
- Опубликовано: 7 авг 2024
- Mini charts are a great alternative to Sparklines offering more features and functionality to make your reports pop.
🔻 DOWNLOAD the Excel workbook here: www.myonlinetraininghub.com/e...
Ghost Series explained here: www.myonlinetraininghub.com/f...
🎓 LEARN MORE: view my comprehensive courses: www.myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e... Наука
Loved the video! I had no idea F4 did that with special pasting!
Hi Mynda.. Happy New Year! Thanks for kicking it off with these interesting mini-charts.. very clever. Thanks for the tips and Thumbs up!
That snap-to-cell alt trick...brilliant!
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!
Happy New Year Mynda, Very nice. Keep them coming!
Love your videos. Thanks for posting content more regularly!
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!
Excellent,Really Helpful Tutorial!Thank You Mynda :):)
Great, informative video....AND you have the BEST accent! I could listen to you for hours!
Wow, thanks!
Came across your videos today and you make it easy to digest while being very informative. Thank you!
Glad you like them, David!
I came here to learn one thing (mini charts) and learned a whole lot more! Good video!
Fantastic to hear that :-)
I like mini charts and many useful tips. Thank you :)
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! 😊
Thank you!! Never knew about Alt-dragging! ♥️
Great to know you discovered something new :-)
great trick! thanks for sharing your knowledge
Amazing video, thank you Mynda
Very cool, a good alternative. Thank you.
Thank you so much for this video
Very beautifully done
I love your videos Mynda. Your Excel knowledge truly amazes me!
Thank you so much, Louis!
@@MyOnlineTrainingHub You just got a new subscriber :)
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!
excellent training. thx.
love this, just built it into my Dashboard. Thank you V much
Great to hear, Simon!
I do love your videos, there
y are so useful. Thanks :)
Thanks, David!
I learned a few things again! thank you!
Great to know it was helpful, Mark :-)
Thanks! You are awesome explaining, great tricks...
Glad you think so, Domingo :-)
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!
Nice video..easy to understand....
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 so cooool i love learning excel from you
Thank you so much! 😃
You're amazing!
All videos are very lovey & most informative. Thank you mam.
Thanks so much 😊
Excellent tip to maximize the space in a dashboard!
Glad it was helpful!
Bonjour et merci pour tes vidéos trop cool
Excellent. Very helpful.
Glad to hear it!
Brilliant!1 Awsome!! Thank you very much!! ♥
Glad you like it!
love your videos. super useful.
Thanks so much, Rich!
thank u so much, it was useful to me
You're welcome, Ramin!
Very useful. Thank you!
Glad to hear that!
Awesome!
Amazing! Thank you for sharing!
Glad you enjoyed it, Sylvia!
Great , learned something new.
Awesome to hear!
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 :-)
How cute! And useful. Great tutor.
Glad you liked them :-)
thank you for your video supports, i like this channel so much
So nice of you :-) Please share it with your friends!
always great Mynda ♥
Thanks again, Hazem!
Thank you!
Glad you liked it!
Amazing, once again.
Thanks again :-)
Mind Blown.
:-) glad you enjoyed it, David!
Great explanation. TQ
Glad you found it helpful, Alan!
Thank you Brilliant video
Glad you enjoyed it :-)
Nice video tutorial. thank you
Thank you :-) Glad you liked the mini charts.
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.
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!
Marvelous!...You are a goddess, thank you so much!
You're so welcome!
Amazing tutorial Munda🙏🙏
Glad you think so!
Love it thanks alot
I'm glad you like it :-)
You are brilliant.
Good job kid.
Thanks so much :-)
Very useful! Thanks :-)
Cheers, Alex :-) Glad you'll be able to use them. Mynda
Thanks!
Pleasure 😊
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.
another one ,you're the best
Glad you enjoyed it, Yoann :-)
Amazing and informative video
Glad you enjoyed it 😊
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 ;-)
Great job
Thanks, Mohammed :-) Please share it with your co-workers. Mynda
Impresed every viewer with your skills :-O
Thank you very much!
Thank you.
You're welcome!
Awesome Mam
Thank you :-)
Brilliant! Thanks!
thank you..
You're most welcome, Pkal!
Nice !
Hope you can use the Mini Charts :-)
Well Done
Cheers, Shakira!
go on /////from yemen ..................that's great
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.
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.
Excelent !
Thank you!
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.
Awesome
Thanks so much :-)
Muuuuuito bom! 👏👏👏👏
Obrigado :-)
@@MyOnlineTrainingHub What? 'o' Do you speak portuguese?
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!
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
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 😊
Just awesomely …
Thank you so much 😀
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.
Thank you! Before watching your videos I spent one hour to draw the trend chart for 30 lines of data. 😞
Glad it helped!
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 :-)
Can you create bar charts or stack charts to show green and red detailing actual vs budget YTD?
Yes 😊
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 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 :)
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.
👌👌👌
Glad you liked it :-)
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.
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
Is it done on Power BI excel?
This is Excel :-)
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
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.
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.
You’re really pretty