Placing TOTALS in a STACKED COLUMN chart in EXCEL.
👩💻 When we create a stacked column chart, we can activate data labels for the value of each section within the stacked column. But what happens when we want to visualize the total for the entire column? We'll learn how in this tip 👍😁.
We'll apply this to a sales summary for a restaurant chain.
00:00 INTRO
00:49 - Step 1: Create a stacked column chart.
04:26 - Step 2: Add another series (or another column to my table) to the chart where the totals per branch are calculated.
05:19 - Step 3: Change the chart type of the new series (the totals) to a line chart.
06:09 - Step 4: Add data labels to this new series.
07:41 - Step 5: Remove the color from the created series line (so it's not visible, only the data label).
08:53 - Step 6: Customize the chart legend to show only what you want.
If you'd like to download the video file to practice, you can download it from the following link:
https://smartprosoluciones.com/coloca...
Did you like it? Support me with a LIKE 👍 or share it with someone who might find this tip useful.
---------------------------------------------------------------------------------------------------------
LET'S STAY CONNECTED! 😁:
Instagram and Facebook: @SMARTpro Academy
► Instagram: / smartproacademy
► Facebook: / smartproacademy
---------------------------------------------------------------------------------------------------------
Would you like to know your current Excel level? Take our free test:
https://maraton.smartprosoluciones.co...
Do you want to catapult your Excel skills 👩🏻💻 👨🏻💻 and stand out from the crowd of professionals? Great news! You have the option to take our courses LIVE ONLINE 😁 or in person in Panama. Visit our website for more information.
https://www.smartprosoluciones.com/cu...
-----------------------------------------------------------------------
💡💻 Get the Microsoft Excel 365 version:
https://click.linksynergy.com/fs-bin/...
🎥💻 I use this program to produce and edit my videos: https://techsmith.z6rjha.net/c/273772...