Column and stacked column charts are visualizations that use height to show contribution to a total. In this video, learn how to create column and stacked column charts.
- One of the most common ways to summarize categories of data is by using bar and column charts. A bar chart uses horizontal lines, whereas a column chart uses vertical lines to show the magnitude of values across a range of categories. In this movie I will show you how to create those two types of charts. My sample file is 0901 Column Charts. And that's a tabloid workbook you can find in the chapter nine folder of the exercise files collection. I currently have a text table set up, where I have category on the rose shelf, so you can see the product category pill here. And then I have the sum of order total, which is basically sum of sales for the data area. If I want to create a bar chart, then I can go to the show me button. Click that to open the panel and the available visualization types are displayed. The horizontal bar chart is on the third line, I'll go ahead and click that button here. And you see I get a horizontal bar chart and I'll clear show me so we can see all of the data. So we can see that robots account for the vast majority of sales, at least by value, and drones are in second place but a bit far behind. It looks like blueprints is the lowest value category. So that's a horizontal bar chart. And you can see that it would fit well in a place that is longer than it is tall. If you want to display this data using vertical bars, that is columns, then you can go to show me, and you can click the stacked bars button, which is right next to the horizontal bars button. So click there and you see that you get a single column, a stacked column that shows all sales and then the colors represent different categories. So blue is blueprints, orange is drone kits, red is drones and so on. If you want to add more detail, such as going by sales region, then you can drag sales region from the dimensions area to columns. Doing so will give you a column for each region and the colors still represent the different product categories. There is one final type of column chart that you can create with data that's in this configuration that is with rose and columns. If I go to show me, and I hover over side by side bars, I can click that button under show me. And you'll see that I have different categories broken down by region. So I have blueprints, and then sales by value within each of the nine regions, then drone kits, drones and so on. If I want to change the order of product category and sales region, to have sales region as the larger category, then I can drag product category to the right of sales region and there you see we have central east and we're broken down by blueprints, drone kits and so on. The coloring still represents region, so blue is central east, orange is north central east and so on. But each of the columns represents one of the categories, blueprints, drone kits and so on. Whether you prefer a bar chart with horizontal bars, or a column chart with vertical bars, all depends on your personal preferences and the needs of your visualization. See what works best and go with it.
- Explain where a user would navigate to seek specific help in Tableau.
- Determine the best approach for using Excel in Tableau.
- Interpret how to use the features and functions of Tableau when creating charts.
- Describe how best to manage data in a worksheet or visualization.
- Explain how to create a selection filter for certain values.
- Explain how to manage data for different chart formats.
Skill Level Beginner
1. Introducing Tableau
2. Managing Data Sources and Visualizations
3. Managing Tableau Worksheets and Workbooks
4. Creating Custom Calculations and Fields
5. Analyzing Data
6. Sorting and Filtering Tableau Data
7. Defining Groups and Sets
8. Creating and Pivoting Crosstabs
9. Creating Basic Visualizations
10. Formatting Tableau Visualizations
11. Annotating and Formatting Visualizations
12. Mapping Geographic Data
13. Creating Dashboards and Actions
Next steps1m 17s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.