How to Instantly Improve Your Excel Charts [Watch This!]

Рет қаралды 33,572

11 ай бұрын

Learn how to create a progress doughnut chart in Excel with this easy-to-follow video.
👩‍🏫 Learn Excel with my courses: bit.ly/progresschart23courses
⬇️ DOWNLOAD the example file here: bit.ly/progresschart23file
CIRCLE CHART ALTERNATIVES:
- Thermometer Charts: www.myonlinetraininghub.com/e...
- Bullet Charts: www.myonlinetraininghub.com/3...
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: www.myonlinetraininghub.com/e...
🎯 FOLLOW me on LinkedIn: / myndatreacy
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
#Excel #ExcelChart #ExcelCharts

Пікірлер: 95

@MyOnlineTrainingHub 17 күн бұрын

❓What tricks do you use to make people read your reports? Learn Excel with my courses: bit.ly/progresschart23courses

@Learning_to_Excel 10 ай бұрын

Love the video Mynda! We found that the circle charts put a positive spin on displaying progress and are a better optic for clients and peers!

@MyOnlineTrainingHub 10 ай бұрын

Interesting to hear that 👍

@user-rg6ze5wd6d 11 ай бұрын

Thank you very much, your videos are always clear and very understandable. They help me a lot in expanding my knowledge of Excel.

@MyOnlineTrainingHub 11 ай бұрын

Great to hear!

@gospelmoto2833 11 ай бұрын

You are not boring Mynda! Thanks.

@MyOnlineTrainingHub 11 ай бұрын

Oh, thank you! 😊

@chrism9037 11 ай бұрын

I have to start doing this with my charts more often, thanks Mynda!

@MyOnlineTrainingHub 11 ай бұрын

Glad they’ll be useful, Chris. 😊

@michaeldavenport9268 11 ай бұрын

This is awesome! Thank you for sharing.

@MyOnlineTrainingHub 11 ай бұрын

My pleasure!

@Viper7513 11 ай бұрын

These videos are absolutely fantastic.

@MyOnlineTrainingHub 11 ай бұрын

Glad you think so! 🙏 please share them with your friends.

@Luciano_mp 11 ай бұрын

Cool charts Mynda. Thank you!

@MyOnlineTrainingHub 11 ай бұрын

Glad you like them!

@marjoriefrancis4560 11 ай бұрын

Good morning Mynda, thank you for another useful demonstration. Have a great day 🙏

@MyOnlineTrainingHub 11 ай бұрын

Thank you! You too!

@sachinrv1 11 ай бұрын

This will require me lots of practice. Thanks for sharing.

@MyOnlineTrainingHub 11 ай бұрын

You’re welcome 😊

@hamza4608 11 ай бұрын

Thanks it's very helpful.

@MyOnlineTrainingHub 11 ай бұрын

Glad to hear that!

@DiamondRock2 11 ай бұрын

Thanx Mynda

@MyOnlineTrainingHub 11 ай бұрын

Pleasure 😊

@pradeepkumarchennam1115 11 ай бұрын

Very very useful information ❤

@MyOnlineTrainingHub 11 ай бұрын

Glad you think so!

@barttitulaerexcelbart9400 11 ай бұрын

Thank you Mynda. A lot of work, but the result is very nice!

@MyOnlineTrainingHub 11 ай бұрын

You are so welcome!

@ShereeJBennett 11 ай бұрын

I use charts for sustainability and this will give it a great new look - Thankyou!

@MyOnlineTrainingHub 11 ай бұрын

So great to hear 😊

@jueroe3753 11 ай бұрын

Thank you very much, I learned something from you again. And someone should say that communication over such a distance is not easy.

@MyOnlineTrainingHub 11 ай бұрын

Wonderful to hear 🙏

@kebincui 11 ай бұрын

Thanks Mynda.👍🌹

@MyOnlineTrainingHub 11 ай бұрын

My pleasure 😊

@elijahajayi987 11 ай бұрын

This is beautiful 👏

@MyOnlineTrainingHub 11 ай бұрын

Glad you like them 🙏

@mogarrett3045 11 ай бұрын

great tutorial as always

@MyOnlineTrainingHub 11 ай бұрын

Glad you liked it!

@markpodesta4605 11 ай бұрын

You know your stuff Mynda! 😊

@MyOnlineTrainingHub 11 ай бұрын

Thanks so much!

@JennTheWriter 11 ай бұрын

Great information! As Always. :)

@MyOnlineTrainingHub 11 ай бұрын

Glad you think so!

@PhuongNguyen-sf3yc 8 ай бұрын

Thank you ! After your video. I can make skill chart for my CV

@MyOnlineTrainingHub 8 ай бұрын

Awesome to hear! Good luck with your job search. 🍀

@shakthiatukorala595 11 ай бұрын

Really interesting...😊

@MyOnlineTrainingHub 11 ай бұрын

Glad you think so!

@MrPotatoeHead002 11 ай бұрын

I really like this tutorial. Might have a crack at this. Cheers

@MyOnlineTrainingHub 11 ай бұрын

Awesome to hear!

@ContemporaryW 7 ай бұрын

new subscriber mam, thank you

@MyOnlineTrainingHub 7 ай бұрын

Welcome 😊

@mohammadharisfahim6614 11 ай бұрын

Stay blessed ❤

@MyOnlineTrainingHub 11 ай бұрын

You too 😊

@steven.h0629 11 ай бұрын

Cool 👍😎✊

@MyOnlineTrainingHub 11 ай бұрын

🙏

@siyadoll 4 ай бұрын

o my god do you know you are the solution of my every problem i would say this because i was working on another video i was stuck on a problem for the last 24 hours you can't imagine my mental condition actually i was working the same thing but stuck yeah this video help me understand everything deeply

@MyOnlineTrainingHub 4 ай бұрын

So pleased I could help 😊

@ikinursiyanto-dj7500 11 ай бұрын

great

@MyOnlineTrainingHub 11 ай бұрын

Glad you like it!

@Seven30onFriday 11 ай бұрын

Nice

@MyOnlineTrainingHub 11 ай бұрын

Thanks 😊

@tun-tunninc.6492 11 ай бұрын

My boss would love you!!!

@MyOnlineTrainingHub 11 ай бұрын

Sounds like if you create these charts your boss will love you too 😉

@tahirshah6979 11 ай бұрын

@@MyOnlineTrainingHubbut my boss confuses when he come around different types of charts. Then it comes my next assignment to make it explained. ☹️

@user-ks8fq9jr9k 11 ай бұрын

With analysis also I don't know anything about it, how can you help me on that. Thanks

@clivepetty2338 11 ай бұрын

Great charts. I was trying to circle or half circle to show trends in a report, but could find or get them to show negative numbers. So slide bar, which was visually less effective then a circle. Must be something about dials.

@MyOnlineTrainingHub 11 ай бұрын

Glad you liked them, Clive! Trends are probably better shown in line or column charts.

@theseusblackwell5252 11 ай бұрын

Funnily enough, I'm just building a report and my charts are indeed boring.

@MyOnlineTrainingHub 11 ай бұрын

😁 not anymore!

@scewing123 11 ай бұрын

This is awesome! Unfortunately, I have a few categories with an extra "Product" so I have some blank donuts. :(

@MyOnlineTrainingHub 11 ай бұрын

Hmmm, you could create a separate segment series for each chart and then factor in a test on the end of SEQUENCE that hides zero if the row in the PivotTable for that series is blank. e.g. *NOT(ISBLANK(B7)) This way the chart will disappear if there's no item in cell B7.

@scewing123 11 ай бұрын

@@MyOnlineTrainingHub Worked perfectly! Thanks so much!

@teoxengineer 11 ай бұрын

The sort cut of shape format is CTRL+SHFT+C >>>> CTRL+SHFT+V It will generate same format of the first shape or chart

@MyOnlineTrainingHub 11 ай бұрын

That doesn't work for me 🤔

@IkMag 11 ай бұрын

For the series of 30 times the value 1 you can use SEQUENCE(30,,1,0) in stead of =SEQUENCE(30,,0)-SEQUENCE(30,,-1)

@MyOnlineTrainingHub 11 ай бұрын

Yes, someone else also said that too. I knew when I was writing that formula that there had to be an easier way, but I couldn't see it at the time 😁

@rusektor 11 ай бұрын

<a href="#" class="seekto" data-time="162">2:42</a> Same as: =SEQUENCE(30,,1,0)

@MyOnlineTrainingHub 11 ай бұрын

😁 I had a brain fart when I was writing that formula! I kept thinking to myself that it had to be easier than my formula...but it didn't come to me!

@rusektor 11 ай бұрын

@@MyOnlineTrainingHub 🙂

@axel_r_ 11 ай бұрын

I am addicted to the "Alt"-key to make sure everything is in line.

@MyOnlineTrainingHub 11 ай бұрын

Alt snaps to grid, shift keeps things in line when copying or moving.

@quentinbricard 11 ай бұрын

Thank you for this video! "Your charts are boring.", what a punchline! 😂😂 Well...actually...that's true 😭😭😭

@MyOnlineTrainingHub 11 ай бұрын

😁 not any more though!

@user-ks8fq9jr9k 11 ай бұрын

Please am just a beginner of the Excel, how can I master this skills with no Excel background

@MyOnlineTrainingHub 11 ай бұрын

You might find this beginner playlist a good place to start: kzfaq.info/get/bejne/g9R3fMSi1dewhIk.html

@tihomirhristov77 11 ай бұрын

💚👍🏻

@MyOnlineTrainingHub 11 ай бұрын

🙏😊

@IamTheReaper911 11 ай бұрын

🤟🤟

@MyOnlineTrainingHub 11 ай бұрын

🙏

@altinsaliu 11 ай бұрын

What is your suggestion when there are more categories (products at this case) ?

@MyOnlineTrainingHub 11 ай бұрын

I'd probably use the column chart thermometer style chart instead of the circles.

@gurvindersingharora5301 11 ай бұрын

Mam, can you upload a video of how to calculate sales in excel in qtd, mtd, ytd, ytg, fiscal year, l6m, ly6m !❤

@MyOnlineTrainingHub 11 ай бұрын

Will keep it in mind for the future.

@gurvindersingharora5301 11 ай бұрын

@@MyOnlineTrainingHub Mam, could you try to upload the video related mentioned above metrics some time in next week. It will be Great help!

@marcusfranconium3392 11 ай бұрын

Always wonderfull to see circil graphs. i use them quite a bit in standard deviations . Now i have a question , On Dashboards as its quite hard create a Plan or example of what you want , and this problem mostly lies in which data should i use or what do i want to be displayed . The steps between raw data and dashboard has a few steps. including having a live connection or link to real time data.

@MyOnlineTrainingHub 11 ай бұрын

Planning what to include in your dashboard should be driven by the business objectives and KPIs you need to make decisions. I always start with what questions should the dashboard answer.

@marcusfranconium3392 11 ай бұрын

@@MyOnlineTrainingHub For me as an ships engineer , its like beeing a kid in a candy store . Another question how would one create a multi dashboard view , i got 3 monitors , and i want to show primary information in one and secondary information in the other .