This Excel Chart will grab your attention (Infographic template included)

Learn how to create Excel graphs that are different to the norm but still visually effective. They are great to include in special reports and dashboards.

We'll cover the dynamic aspect of the chart, highlighting the use of conditional formatting to emphasize the most significant data. This includes dynamically highlighting the weekday with the maximum number of users, ensuring the chart updates automatically with new data. The tutorial guides viewers on how to create shapes within charts and adjust them to prevent distortion, a key factor in maintaining the chart's visual appeal.

Moreover, the video covers advanced techniques such as adding data labels, utilizing stacked column charts, and implementing conditional formatting for rounded column charts. This in-depth guide not only teaches how to visually enhance charts in Excel but also ensures that the data remains dynamic and responsive to changes.

00:00 Why Create a Non-Standard Column Chart in Excel
01:48 Start with Basic Column Chart
02:44 Conditional Formatting of Excel Column Chart for MAX-Value
05:51 Create Round Shape for Excel Column Chart
07:45 Prevent Stretching of Round Shape in Column Chart
10:41 Add Data Labels to Excel Chart
12:45 Add Conditional Formatting to Rounded Column Chart

This video shows you how to create special (non-standard) Excel graphs or info-charts in Excel. Not only that but it also shows you how you can conditionally format your graph to highlight specific categories. In this example, I show you how to highlight the week day that has the most users logged on to a system, but you can apply the same technique to any other logic as well.

After that, I show you how you can add shapes to charts. This attracts the attention of your readers because it's different to what they are used to seeing. The problem with this technique is that it stretches out the shape for the bigger data sets so depending on the shape you are using, they are no longer harmonized.

As a last step, I show you a trick you can use to create harmonized shapes in your Excel graphs. It's all a matter of proper data preparation before you draw out the chart.

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel

[GPMGify]

Wherever I work I’m considered the Excel Guru. But watching your videos makes me realize that I can still learn so much from you! If YouTube wouldn’t exist, it would need to be invented just to show your videos!
Plus: your teaching skills are phenomenal! Your voice is so easy to follow. I can’t see the slightest room for improvement as your classes are simply perfect!!! Thank you Leila!

[abdulfattahalhazmi]

Leila, I am still wondering why your subscriber is relatively low; it is, in my opinion, the best youtube channel explaining Microsoft Excel. So, it deserves millions and millions of subscribers. I really like it, addicted watching it, and enjoying it. Thank you very much :)

[Trancical]

Although this post is somewhat old, I do believe Leila has the absolute best teaching style. The content and delivery are first class and the clear instructions are simple to follow. I look forward to learning more and watching this star shine.

[umranshahid]

This is Umran from Pakistan. Thank you very much Leila. I regularly watch your videos. You really have a good command over MSExcel. Your method of explaining any formula is very good. You elaborate everything in a clear way. I have used the functions/formulas learnt from your videos and highly appreciated. All this is due to due to your proper guidelines. Thank you very much indeed!

[Acheiropoietos]

So clever. I have been using Excel for 20+ years and this never occurred to me. So happy I found your channel!

[Merinkroft]

I was just randomly browsing youtube and found that video by chance. Your video just easily won the competition and i couldn't stop watching it. Great work, I cannot wait to show my new improved excel skills at work!

[craigwatkins]

About a month ago, my job responsibilities changed. I now had to use Excel to track all kinds of metrics. I had NEVER used Excel, so I was overwhelmed to say the least.

I resorted to YouTube searches to help me. Within a week, I had people asking "you did that in Excel?!".

Your videos have helped me in such a great way - and I am now the "go to" guy when people have Excel questions. Obviously I don't know everything about Excel, but I know I can either figure it out - or "research it" in You tube!

Your training videos ROCK!

[kasunsuraj]

At last I found the most clear and most understandable excel tutor in youtube. Hats off, you are truly amazing. May God bless you with his showers of wisdom. Thanks a lot for sharing your knowledge with everyone in the world.

[sanikanaik]

Simply amazing! Being an Intern I did this entire chart manually 🤦 A huge thanks to you for these amazing videos! Saving the interns lives 🤭

[NarendraPaiG]

I have worked in excel for long.. but copy pasting that object on a series is a thing - I never knew in last 15 years.. Great info... The color formatting is also new to me, in a graph... Keep educating...

[beaudene]

I don't even use excel, but I watched. Fascinating. Keep it up Leila. ^_^

[cretivetoy]

I was lucky to full upon your YouTube channel and learnt so many things. I now use a number of your lesson to make my Excel data easier to use and display. Thank you.

[johannyjacobsen]

Wow! I also agree that this is the BEST Excel Toutube channel ever

[shahidstate]

Being using excel for almost 18 years I never see these magic, thanks a lot and proud of you.

[silversam]

Excellent tutorial! I never considered personalizing my charts and data representations but you make it easier.

[comichosofrianoluis]

I don't have enough words to describe how your channel is helping me in my career of Business Analyst. Thank you for all the content that you have been posting. I'm writing from Mozambique in Africa. May God keep blessing your life so you can keep teaching us.

[isoboyehorsfall]

This is truly great. I can learn excel while performing the required task. Thanks Leila

[nesao]

Dear Leila, Ive been looking at several online Excel sessions during the last week (e.g. Excel is fun etc), you are far the best one and the most beautiful! :-) which is helping to stay focused!

[NQuiz]

Wow! I love your videos. I am SO Happy to have found you. THANKS!

[Robert]

Hope you don't think this is too corney, but I think you are visually appealing and you have my attention. Seriously, I enjoy your videos, you have great excel tips and tricks and have a soothing presentation quality. I've been using excel for a really long time but decided to sharpen up my skills and learn what the newer versions can do and I am so glad I found you!