Build Impressive Charts: It's NOT your usual Bar Chart (Infographics in Excel)
1.2 میلیون بار بازدید -
6 سال پیش
-
Join 400,000+ professionals in our
Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou...
Unlock the power of info charts in Excel with our comprehensive guide! Whether you're a beginner or a seasoned Excel user, this tutorial is packed with insights to help you create dynamic and visually appealing info charts. From basic setups to incorporating symbols and ensuring dynamic updates, we've got you covered.
📊 What You'll Discover:
▪️ Creating Clustered Bar Charts: Learn how to set up and manipulate clustered bar charts for the foundation of your info chart.
▪️ Incorporating Rounded Edges: Add a touch of style with rounded edges for a sleek and modern look.
▪️ Dynamic Symbol Integration: Seamlessly integrate symbols into your chart and make them dynamic with real-time data updates.
▪️ Customizing Data Labels: Enhance readability with customized data labels, tailored to your chart's needs.
Create better Excel reports by improving your existing charts with the smart use of Icons.
In this video you learn how to create a bar chart that includes the male/female icon in a dynamic way (I will also show you how you can add shapes inside charts - this way, you can change your series to look like any shape of your choice) - you can of course replace these icons with any icon of your choice. You could for example use images of your products.
This is an example of how you can use some chart tricks that allow you to create infographics or infocharts in Excel. You don't need to stick to the default chart types, you can improve on these to fit your corporate reporting style.
00:00 Info Charts in Excel
00:43 Prepare Clustered Bar Chart
04:09 Created Rounded Edges for Bar Chart
05:50 Add Data Label to Bar Chart
06:54 Insert Icons to Bar Chart
08:06 Dynamic Placement of Icon
★ Links to related videos: ★
Special Excel Charts: This Excel Chart will grab your atten...
➡️ Join this channel to get access to perks: @leilagharani
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: https://www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: Instagram: lgharani
LinkedIn: LinkedIn: xelplus
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
Unlock the power of info charts in Excel with our comprehensive guide! Whether you're a beginner or a seasoned Excel user, this tutorial is packed with insights to help you create dynamic and visually appealing info charts. From basic setups to incorporating symbols and ensuring dynamic updates, we've got you covered.
📊 What You'll Discover:
▪️ Creating Clustered Bar Charts: Learn how to set up and manipulate clustered bar charts for the foundation of your info chart.
▪️ Incorporating Rounded Edges: Add a touch of style with rounded edges for a sleek and modern look.
▪️ Dynamic Symbol Integration: Seamlessly integrate symbols into your chart and make them dynamic with real-time data updates.
▪️ Customizing Data Labels: Enhance readability with customized data labels, tailored to your chart's needs.
Create better Excel reports by improving your existing charts with the smart use of Icons.
In this video you learn how to create a bar chart that includes the male/female icon in a dynamic way (I will also show you how you can add shapes inside charts - this way, you can change your series to look like any shape of your choice) - you can of course replace these icons with any icon of your choice. You could for example use images of your products.
This is an example of how you can use some chart tricks that allow you to create infographics or infocharts in Excel. You don't need to stick to the default chart types, you can improve on these to fit your corporate reporting style.
00:00 Info Charts in Excel
00:43 Prepare Clustered Bar Chart
04:09 Created Rounded Edges for Bar Chart
05:50 Add Data Label to Bar Chart
06:54 Insert Icons to Bar Chart
08:06 Dynamic Placement of Icon
★ Links to related videos: ★
Special Excel Charts: This Excel Chart will grab your atten...
➡️ Join this channel to get access to perks: @leilagharani
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: https://www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: Instagram: lgharani
LinkedIn: LinkedIn: xelplus
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
6 سال پیش
در تاریخ 1397/02/06 منتشر شده
است.
1,283,778
بـار بازدید شده