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

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

11 ай бұрын

Interesting to hear that 👍

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

@MyOnlineTrainingHub

Жыл бұрын

Glad they’ll be useful, Chris. 😊

You are not boring Mynda! Thanks.

@MyOnlineTrainingHub

11 ай бұрын

Oh, thank you! 😊

Cool charts Mynda. Thank you!

@MyOnlineTrainingHub

Жыл бұрын

Glad you like them!

This is awesome! Thank you for sharing.

@MyOnlineTrainingHub

Жыл бұрын

My pleasure!

These videos are absolutely fantastic.

@MyOnlineTrainingHub

Жыл бұрын

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

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

@MyOnlineTrainingHub

Жыл бұрын

Thank you! You too!

Very very useful information ❤

@MyOnlineTrainingHub

Жыл бұрын

Glad you think so!

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!

Thanks it's very helpful.

@MyOnlineTrainingHub

Жыл бұрын

Glad to hear that!

You know your stuff Mynda! 😊

@MyOnlineTrainingHub

Жыл бұрын

Thanks so much!

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

@MyOnlineTrainingHub

11 ай бұрын

You’re welcome 😊

This is beautiful 👏

@MyOnlineTrainingHub

Жыл бұрын

Glad you like them 🙏

Thanks Mynda.👍🌹

@MyOnlineTrainingHub

Жыл бұрын

My pleasure 😊

Great information! As Always. :)

@MyOnlineTrainingHub

Жыл бұрын

Glad you think so!

great tutorial as always

@MyOnlineTrainingHub

11 ай бұрын

Glad you liked it!

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

@MyOnlineTrainingHub

Жыл бұрын

You are so welcome!

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

@MyOnlineTrainingHub

Жыл бұрын

So great to hear 😊

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

@MyOnlineTrainingHub

Жыл бұрын

Wonderful to hear 🙏

Thanx Mynda

@MyOnlineTrainingHub

11 ай бұрын

Pleasure 😊

Really interesting...😊

@MyOnlineTrainingHub

Жыл бұрын

Glad you think so!

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 😊

Stay blessed ❤

@MyOnlineTrainingHub

Жыл бұрын

You too 😊

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

@MyOnlineTrainingHub

Жыл бұрын

Awesome to hear!

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

@MyOnlineTrainingHub

8 ай бұрын

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

new subscriber mam, thank you

@MyOnlineTrainingHub

7 ай бұрын

Welcome 😊

Cool 👍😎✊

@MyOnlineTrainingHub

Жыл бұрын

🙏

Nice

@MyOnlineTrainingHub

Жыл бұрын

Thanks 😊

great

@MyOnlineTrainingHub

Жыл бұрын

Glad you like it!

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

Жыл бұрын

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

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

@MyOnlineTrainingHub

Жыл бұрын

😁 not anymore!

My boss would love you!!!

@MyOnlineTrainingHub

Жыл бұрын

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. ☹️

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 🤔

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

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

Жыл бұрын

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 😁

2:42 Same as: =SEQUENCE(30,,1,0)

@MyOnlineTrainingHub

Жыл бұрын

😁 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

Жыл бұрын

@@MyOnlineTrainingHub 🙂

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

@MyOnlineTrainingHub

11 ай бұрын

😁 not any more though!

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

@MyOnlineTrainingHub

Жыл бұрын

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!

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

@MyOnlineTrainingHub

Жыл бұрын

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

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: kzread.info/dash/bejne/f6J7q8OqoNSyhLg.html

💚👍🏻

@MyOnlineTrainingHub

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.

🤟🤟

@MyOnlineTrainingHub

Жыл бұрын

🙏

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!

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 .