![Data Design Style](/img/default-banner.jpg)
- 35
- 61 186
Data Design Style
เข้าร่วมเมื่อ 5 ต.ค. 2023
Learn to present information clearly and effectively with data visualizations: charts, graphs, shapes, images, maps and more!
Whether you have a message you want to convey, a story to tell, or complex information to explain … Data Design Style can help you hone your skills in presenting data of all kinds. I hope you find these tutorials helpful!
Catherine
Founder, Data Design Style
Website: datadesignstyle.com
Whether you have a message you want to convey, a story to tell, or complex information to explain … Data Design Style can help you hone your skills in presenting data of all kinds. I hope you find these tutorials helpful!
Catherine
Founder, Data Design Style
Website: datadesignstyle.com
Data Bars in Cells turn GREEN at 100% - Excel Tutorial
In Microsoft Excel, data bars can be assigned only one color. But there is a way to make the bars appear to automatically turn green (or whatever color you want) at 100%. This video explains how to do this, by using two conditional formatting rules. I hope it’s helpful!
....................................................
CHAPTERS:
0:00 Introduction
0:19 Insert data bars
0:55 Turn green if 100%
3:03 Format borders
3:36 Hide values on bars
4:32 Summary
....................................................
Video is made using Filmora.
Website: www.DataDesignStyle.com
#ExcelDataBars #ExcelTutorial
....................................................
CHAPTERS:
0:00 Introduction
0:19 Insert data bars
0:55 Turn green if 100%
3:03 Format borders
3:36 Hide values on bars
4:32 Summary
....................................................
Video is made using Filmora.
Website: www.DataDesignStyle.com
#ExcelDataBars #ExcelTutorial
มุมมอง: 92
วีดีโอ
Top 10 plus All Other Subtotal in Pivot Table - Excel Tutorial
มุมมอง 18614 วันที่ผ่านมา
Learn how to create a Top 10 list - PLUS a consolidated subtotal for “all other categories" - in an Excel pivot table. Our example reports the number of customers by state of residence, and the final table includes the sum, percent of total, and rank. I hope you find this helpful! .................................................... CHAPTERS: 0:00 Introduction 0:22 Create pivot table 0:59 Find ...
How to Create a Combination Chart (Combo Chart) in Excel
มุมมอง 1.6K21 วันที่ผ่านมา
Learn how to create Combination Charts (also called Combo Charts) in Microsoft Excel. We will look at two examples: (1) a simple chart that combines a bar chart and a line chart, plus another version of it that combines an area chart and line chart, and (2) a more complex example that combines a bar with two lines and requires a dual axis. .................................................... CH...
How to Format a Bar Chart in Canva
มุมมอง 561หลายเดือนก่อน
In this video, we learn how to format a bar chart using the design tool Canva. We will look at the formatting options available on the Data panel, the Settings panel, and the Edit Toolbar. Topics include how to formta numbers on the chart as currency, and how to display years (data type number) on the chart as categories (data type text). I hope this is helpful! ...................................
How to Track Progress with a Gradient Color Scale in Excel - using Conditional Formatting
มุมมอง 505หลายเดือนก่อน
In this Microsoft Excel tutorial, we create a data visualization to track which steps in a process are complete, using a gradient color scale from light yellow to dark green. Instead of creating a chart, we use the conditional formatting feature to add color highlighting directly in the cells. I hope this is helpful! .................................................... CHAPTERS: 0:00 Introducti...
Automatically change Bar Chart COLORS based on a condition - Excel tutorial
มุมมอง 1.1K2 หลายเดือนก่อน
In this Microsoft Excel tutorial, we create a bar chart that is dynamic: the colors of the bars change automatically based on a benchmark value. In the first half of the video we prepare the data using formulas. In the second half we create and format the chart. There is a bonus tip at the end where we add the benchmark line to the chart. .................................................... CHA...
How to show Actual and Forecast on a Single Line Chart in Excel
มุมมอง 2.4K2 หลายเดือนก่อน
If you have a dataset with actual values and forecasted (or projected) values, this video will show you how to display them together on the same line chart, using Microsoft Excel. There are different methods you could use, this video uses the strategy of (1) putting the Actual and Forecast numbers in two different columns, (2) creating a line chart, and then (3) using a work-around to connect t...
How to Create a Layered Pie Chart (Sunburst Chart) in Excel
มุมมอง 6513 หลายเดือนก่อน
Learn to create a pie chart with multiple layers in Microsoft Excel. This type of chart is sometimes called a Sunburst Chart, Layered Pie Chart, or Nested Pie Chart. This design is great for data that can be grouped into broad categories, or data that has a natural hierarchy. .................................................... CHAPTERS: 0:00 Introduction 0:41 Prepare the Data 2:10 Format the C...
How to Add an Average Line and Shading to an Excel Chart
มุมมอง 1.5K4 หลายเดือนก่อน
How to add an average line to a line chart in Microsoft Excel, and shade the area of the chart that is below average. We will set up the data in columns, and create the desired result using a combo chart. We will also cover how to format the colors and add a direct data label. I hope you find this helpful! .................................................... CHAPTERS: 0:00 Introduction 0:15 Cre...
Create Sparklines in Excel Step by Step Tutorial
มุมมอง 2165 หลายเดือนก่อน
How to create and format sparklines in Microsoft Excel. We’ll learn how to change the line and marker colors, display specific markers (such as negative points), group and ungroup sparklines, adjust the vertical axis range, and work with dates. This video includes how to create line, column, and win/loss sparklines. I hope you find this helpful! ....................................................
How to Format a Basic Chart in Excel - Step by Step Tutorial
มุมมอง 4.5K5 หลายเดือนก่อน
Learn how to create a basic chart in Microsoft Excel, and the different ways to format a chart. This video includes how to add and remove chart elements (titles, axes, data labels, and a legend), customize the formatting, add data to an existing chart, and change the chart type. CHAPTERS: 0:00 Intro 0:16 Create a chart 1:38 The chart object 1:59 Chart elements 5:19 Format options 8:35 Add data ...
Visualizing Data - A Guide for Designing Bar, Line, and Pie Charts
มุมมอง 2146 หลายเดือนก่อน
This video provides guiding principles for designing effective bar charts, line charts, and pie charts. I also created a free, one-page PDF Guide that summarizes the information in this video. You can download it here: DataDesignStyle.com/Guides/#DataVisualizationGuide CHAPTERS: 0:00 Intro 0:20 Bar Charts 3:42 Line Charts 7:32 Pie Charts 11:12 Summary I hope you find this helpful! ................
Formatting Text in Excel - Titles, Column Headers, Paragraphs (for beginners)
มุมมอง 3416 หลายเดือนก่อน
Learn how to work with text in one cell (or in one merged cell): add line breaks, merge and wrap text, format parts of a cell, and navigate within a cell. This video also includes basic, time-saving tips. It is designed for beginners. CHAPTERS: 0:00 Intro 0:33 Edit using F2 0:48 Line break 2:02 Autofill 3:53 Merge and wrap text 4:47 Navigate 6:16 Line spacing 6:54 Apostrophe 8:34 Navigate and s...
How to display Totals above a Stacked Column Chart in Excel
มุมมอง 3.8K7 หลายเดือนก่อน
Learn how to display totals above a stacked Column Chart (a vertical bar chart) in Microsoft Excel. Note: if you want to display totals on a stacked ROW chart (a horizontal bar chart) in Excel, it requires a different strategy. So I made a separate video showing how to do this: th-cam.com/video/csWi72imMHI/w-d-xo.html I hope you find this helpful! ..................................................
How to display Totals on a Stacked ROW Chart in Excel - 2 Methods
มุมมอง 5667 หลายเดือนก่อน
This video demonstrates two different methods for displaying totals on a stacked Row Chart (a horizontal bar chart) in Microsoft Excel. The first method is easier, but requires some manual adjustments to the horizontal axis. The second method is more elegant: it works really well, but it takes some extra steps. Chapters: 0:00 Intro 0:12 Easy method 3:26 Elegant method Note: If you are intereste...
How to use the Pictogram Chart feature in Canva
มุมมอง 2.5K7 หลายเดือนก่อน
How to use the Pictogram Chart feature in Canva
How to manually make a Pictogram in Canva - step by step
มุมมอง 6758 หลายเดือนก่อน
How to manually make a Pictogram in Canva - step by step
How to make a Dual Axis Chart in Excel
มุมมอง 1.1K9 หลายเดือนก่อน
How to make a Dual Axis Chart in Excel
How to make an Infographic using a Donut Chart - Canva tutorial
มุมมอง 1.2K9 หลายเดือนก่อน
How to make an Infographic using a Donut Chart - Canva tutorial
How to make a Staircase Infographic for a Step-by-Step Process
มุมมอง 1819 หลายเดือนก่อน
How to make a Staircase Infographic for a Step-by-Step Process
How to make a Bar of Pie Chart in Excel
มุมมอง 6K9 หลายเดือนก่อน
How to make a Bar of Pie Chart in Excel
Infographic Do's and Don'ts - page layout, graphics, colors
มุมมอง 829 หลายเดือนก่อน
Infographic Do's and Don'ts - page layout, graphics, colors
How to Create an Infographic with a Radial Design in Canva
มุมมอง 1579 หลายเดือนก่อน
How to Create an Infographic with a Radial Design in Canva
How to change the color of 1 bar in Canva Chart
มุมมอง 7K9 หลายเดือนก่อน
How to change the color of 1 bar in Canva Chart
Bar Chart Do's and Don'ts - Best Practices for Bar Chart Designs
มุมมอง 5210 หลายเดือนก่อน
Bar Chart Do's and Don'ts - Best Practices for Bar Chart Designs
Introduction to Charts and Graphs in Canva
มุมมอง 2.4K10 หลายเดือนก่อน
Introduction to Charts and Graphs in Canva
How to show fractions in a Pictogram with Canva
มุมมอง 36010 หลายเดือนก่อน
How to show fractions in a Pictogram with Canva
Line Chart with Design Elements using Canva
มุมมอง 79310 หลายเดือนก่อน
Line Chart with Design Elements using Canva
5 Benefits of Using a Chart instead of a Data Table
มุมมอง 5810 หลายเดือนก่อน
5 Benefits of Using a Chart instead of a Data Table
Nice❤
Thank you for your kind comment! 🙂- Catherine
❤nice
Thank you! - Catherine
There's no need to show percentage complete and data bars separately! Looks rookie and a bit unprofessional like me
LOL. If you mean showing the percentage complete and data bars in two separate columns, I included that option at the end of the video just in case it is needed. It probably doesn’t make sense when the value is percentage complete, but you never know when a client may request it that way. I do agree with you, it usually makes more sense to show the values in the same cells as the data bars. - Catherine
❤nice
Thank you! - Catherine
❤nice
Thank you for watching the video! - Catherine
Great. Thank you. Expecting more coming.
Thank you! I am trying to produce videos more often, so I appreciate your encouragement! - Catherine
Thank you for sharing the video. It was helpful. 😊
Great! I am really glad it was helpful. - Catherine
Nice❤
Thanks! - Catherine
Nice❤🌻
Thank you for your kind comment! - Catherine
Thanks a lot 👍
I'm glad it was helpful! - Catherine
Can we animate this chart like the circular type?
For some reason, the Progress Ring (example 3 in the video) does not come with built-in animation like the Donut Chart. You could add the "wipe" animation setting, but it's not as cool as the Donut where it looks like a circle is drawn on the screen. I hope this answers your question, if I misunderstood, please let me know. Thanks! - Catherine
If you want to download the Excel workbook used in this video, there is a link to the Practice File in the description above. This way, you can create the chart along with the video, or practice later on your own. I hope it’s helpful. - Catherine
Thank you! Got stuck and thanks to your tutorial i started from scratch and completed it.
Great! I'm glad it helped. - Catherine
how to show decimal numbers?
hi @AmlanMannagcad09103 to show numbers with decimals, I think you have to make sure the data you paste in for the chart already displays decimals to the precision you want. From there, you can set the number of decimals that show on the chart by using this method: Select the chart, and click on the Data tab on the left hand panel. In the data table, at the top of each column is a column heading that says “123” or “ABC” - click on the heading for the column you want to format, click on the 3 dots for “More” and then you'll see a dropdown menu where you can choose “123 Format”. A popup window will appear that allows you to specify the number of decimals, along with other settings. If you want to see this explained in a video, I recently posted one called How to Format a Bar Chart in Canva (the link is in the description above, and here th-cam.com/video/pLj615VUg-E/w-d-xo.html ). It covers number formats including decimals starting at 1:26. I hope this helps! - Catherine
❤ very nice
Thank you! - Catherine
❤nice
Thanks! - Catherine
❤nice
Thank you! - Catherine
Super helpful ! thanks!
That's great to hear. Thanks! - Catherine
brilliant, this is so different
Thank you for your kind comment! - Catherine
Great class teacher.
Thank you so much! - Catherine
I like the design and the idea as well, thanks! But, just one important issue -> typing the numbers into the table area to trigger COFO-> NO WAY! - it's just not the real-life case. I highly recommend to use an ID column as first column with a validation list to choose the ID quickly, and based on this column a dynamic formula can set the numbers automatically - I think, that's the a more advanced approach that I'd ask from my employee. -------------------------------------------------------------------------- so for example as a staging table: Process ID Process Step JD Job Description BR Budget Requested BA Budget Approved JA Job Advertised IS Interviews Scheduled IC Interviews Completed JO Job Offered CH Candidate Hired -------------------------------------------------------------------------- And an example formula to make the table area dynamic: > HiringStatusStaging=LAMBDA([statusid], LET(id, IF(ISOMITTED(statusid), "", statusid), seq, IFS( id = "JD", 1, id = "BR", 2, id = "BA", 3, id = "JA", 4, id = "IS", 5, id = "IC", 6, id = "JO", 7, id = "CH", 8, TRUE, ""), status, IFERROR(SEQUENCE(, seq), ""), status)) --------------------------------------------------------------------------
Thank you! And, thanks for sharing your idea - I like it! Your method would make the table easier to update and more dynamic. It's good to share ideas, so we can all help each other. 🙂 - Catherine
You're a kid 😊
Thanks for watching the video! 😊 - Catherine
So helpful Thank you sooooo much
Great! I am so glad it was helpful. - Catherine
amazing! tysm!
I'm so glad this was helpful! Thank you - Catherine
Amazing! I just learned 10 things I didn’t know that Canva offered! Thank you.
I am so glad you liked this video. Thank you! - Catherine
Thank you so much! I really enjoy your videos and look forward to seeing more. Keep up the great work
Thank you for such a nice comment! I really appreciate it. - Catherine
Thank you. I really enjoyed your videos.
That is so nice to hear. Thank you! - Catherine
Nice but Pound N/A..... LMAO 😂 since when did hash became a pound 🤪
LOL! That's what we called it way back when. 🤣- Catherine
Great.
Thank you! - Catherine
This is 100% new information for me, I was not even aware of "Sparklines". Thanks so much for sharing this, and all of your excellent content!
Thank you! I am glad it was helpful. - Catherine
Thank you
I am glad you liked this video! - Catherine
Thank you. I really liked it and you explained it really well. Please continue the series and when you have the time if you can share other analytics techniques too, like in pivot tables etc, it'll be really helpful. Thanks again.
Thank you for such a nice comment! I really appreciate your suggestion, and I will add other topics like pivot tables to my content. Thank you! - Catherine
Great tip. Do you know maybe how to make the values appear at the end of each bar? i don't want to put them in manually, so is there a possibility for this? For example 11.000 for the City A. Thank you!
Thanks! Unfortunately, there is not a way to display data labels above a vertical bar chart in Canva. I always have to add the labels manually as text fields. Hopefully it's a feature they will add soon. - Catherine
Is this a paid version of canva?
Yes, I used a paid version of Canva to create this video. However, I just looked at the free version, and most of the chart features in the video seem to also be available in the free version of Canva. - Catherine
The presentation is awesome, every step explained very smoothly. Looking forward for more such videos on Excel, Power Point and Canva....Keep it up. May Allah bless you.
Thank you for such a nice comment! I really appreciate it. I am working on more videos. Thanks again! - Catherine
Your helpful videos are greatly appreciated; I eagerly anticipate your upcoming releases!
I am so glad to hear that. Thank you for the encouraging comment! - Catherine
Very useful chart! Thank You 🎉🙌
I am glad this was helpful! Thank you - Catherine
thanks for teaching step by step it is very helpful to me to learn 😘❤🌹
I am so glad this was helpful! Thank you! 🙂 - Catherine
thanks so much for teaching me on this new skill step by step it very helpful!🌹❤
Great! Thank you for your kind comment. 🙂 - Catherine
I wish you zoomed out your ribbon it's very helpful this vedoe mem
Thank you! I will add more zooming in and zooming out in my future videos. I appreciate your comment! - Catherine
Amazing
Thanks for your nice comment! - Catherine
Good stuff... Would appreciate if you can add practice files as well 😊
Thanks! And thank you for the suggestion about adding practice files, I put that on my To Do list and will hopefully have them out there soon. 🙂 - Catherine
Very helpful - thanks for teaching me this new skill!
I'm glad this was helpful! - Catherine
Need more creative and ideas data design formats.😊
Thank you for the feedback! I just started this channel a few months ago, so I really appreciate suggestions for moving forward. 🙂 - Catherine
❤
Thanks! 🙂 - Catherine
Thank you Nice
❤
Thank you! 🙂 - Catherine
Well done
Thank you! - Catherine
Hey, keep up the good work.
Thank you! I appreciate your kind comment. - Catherine
Excellent Job, I am always glad to learn some new tricks. Keep up the good work.
That is great to hear. Thank you for your encouragement! - Catherine