Create basic charts: Bar, Stacked Bar, Line & Scatter in Tableau

Lukas Halim
A free video tutorial from Lukas Halim
Analytics Professional
4.5 instructor rating • 2 courses • 58,689 students

Lecture description

  • Create a bar chart

  • Create a line chart

  • Create a scatterplot

  • Create a stacked bar

  • Create a chart to show specific values (crosstab, highlight table)

Learn more from the full course

Tableau Specialist Certification Prep

Includes videos covering all exam guide topics, downloadable study guide, and THREE full-length practice exams!

02:20:41 of on-demand video • Updated May 2021

  • Prepare to pass the Tableau Specialist exam with the two included full-length practice tests!
  • Create live data connections and data extracts. Combine data sources with joins, blends, and unions.
  • Visualize with charts, charts, maps, and text tables. Combine views in interactive dashboards and stories.
  • Organize your data with filters, sorts, hierarchies, groups, and sets.
  • Understand difference between dimensions and measures, discrete fields and continuous fields, table calculations and aggregate calculations.
  • Answer knowledge based theoretical questions and hands-on questions on the Tableau Specialist curriculum topics.
English [Auto] If you take a look at the Tableau desktop specialist exam guide, there is a section called Exploring and Analyzing Data, and under that there's a bullet saying basic charts. And so if we start, they're going to switch to Tablo and start working through those topics. So first, I'm going to open my s superstore data. And bring in the southern and start a new worksheet. So I want to create a bar chart to begin with and so I'm going to look and see for horizontal bars. What I need is I need at least one measurement. So if I add, for example, sales to my view, then I have a very simple bar chart. It's only got one value, right? Because there are no dimensions to create headers on the bottom. So I need to add a dimension down here so that I'll have headers. So I'm going to I could either drag it here or I could drag it down down here like this. Either way, I'm going to drag the region over to columns and that's going to now create a header. However, there's only one region my data set, so that's kind of a boring header, just as s so maybe I'll take that out. Let's do a different one. Let's try a product subcategory. So now I have a more interesting bar chart because instead of a single bar, it's basically segmenting the data by the product subcategory. And so this is saying when I sum up the value of sales for all of the rows where the subcategories, accessories, I get a total sales of twenty seven thousand two hundred seventy seven. That's rounded. But I can change that Rdio format. And let's see, we can change our number format here to use more decimal places if we want. So now I see the seventy five there so I can do it to one decimal place. Right. And I can adjust it basically and I can also change it to use a currency instead. Right. So now it's got dollar sign and so I can make some adjustments with the formatting. So here's my bar chart, basic bar chart. And if I want to do a stack bar chart, I would need a second dimension. Right. So I suppose I want to have the segment in this as well. I could do this. Add this here and now. My bar chart. Those bars are now divided by the business segment. So now I can see all of the different product subcategories for each product subcategory. The bar is divided by the segment. So basically the blue represents the consumer segment, the orange represents the corporate, and then the red represents the Home Office. If we click this, we can actually see over here there's a legend like it's hidden by the show me. But if I click the show me again, it'll hide it, right? So now I can see that there's this legend here that says blue is consumer, orange is corporate and red is home office. And also in the Marks area, it shows me that segment is represented by color so that each different segment is a different color. So that's one option that's a little more complicated bar chart. The other thing I can do is a side by side bar. Right. So now I'm showing the consumer segment, the corporate segment and the Home Office segment in different sections. And then within each section, it shows me all of the different product subcategories where I could switch it and move it this way. And now I see each product subcategory on the top with its own area. And then within that next to it, I see consumer, corporate, home office, consumer, corporate, home office. So this shows me each subcategory and then within each subcategory business segment. The next topic is create a line chart and line charts are different from bar chart in that they always involve a date dimension. And so I'm going to begin my line chart by adding order, date and sales. And then I go to the show me time and I select lines discrete. And so here's my line chart. And since it's a line chart using a discrete date, what I get on the bottom is headers, because when there's a discrete field and this is blue indicating discrete, I get headers. If I switch to a continuous line chart, I instead get an axis. And so we'll talk more in the course about the difference between discrete and continuous. But basically here's my continuous value. And so I get an axis versus my discrete and so now I get headers. So that's a line chart and if I click the plus, then it will expand and give me more detail on the line chart. So now I'm seeing the quarter and now I'm seeing the month and now I'm seeing the day. Right. So that and these are all discrete. So each of these is a separate header, but I can flip and do continuous. And so now I see the daily sale values on my line chart. All right, the next topic under basic charts is a scatterplot and a scatterplot is useful for looking at two measures and seeing how they vary in relation to each other. So the obvious one here would be profit and sales. And so now I just get one dot because it's showing me overall what the sales and the profit are. If I do disaggregate, then I'll see dots for every single transaction in my data set. Right. Each of these represents only one transaction here. So this is just saying for this particular order, the profit was this and the sales were that right for this particular point. But if I remove aggregate measures, then I can see, for example, how the total sales and the total profit vary by product name. Right. So what which product has the highest total sales? Right. It's this one. And however it you see it has negative profit. Right. So this one, it looks like it's good on both the profit and the sales are both positive.