In this article, we will learn how to draw a line graph in tableau worksheet to do further operations.
Tableau – a brief note
Tableau is a very powerful data visualization tool that can be used by data analysts, scientists, statisticians, etc. to visualize the data and get a clear opinion based on the data analysis. Tableau is very famous as it can take in data and produce the required data visualization output in a very short time.
Line graphs
A line graph, also known as a line chart, is a type of chart used to visualize the value of something over time. For example, a manufacturer, who manufactures product X may plot the number of product sold over time to analyze the trend. The line graph consists of a horizontal x-axis and a vertical y-axis.
Dataset used in the given examples is Dataset.
Visualization with line graph
For this we have to follow some steps :
- Open Tableau tool and connect a dataset into it.
- Drag and drop the one sheet of the connected dataset.
- Click on Sheet1 (at the bottom) to open the tableau worksheet.
- On clicking Sheet1 you will get whole dataset attributes on the left side and a worksheet for work.
- To draw a line graph you have to select a minimum of two attributes( one in a row and one in a column) by dragging and dropping. Then select the chart option as a line.
Example 1:
Example 2:
- Select the Region and Sales fields as column and row respectively.
- Select the chart type line graph.
- Drag and drop the subcategory field in Marks section, choose color ( by clicking three dots near it) to apply different color that makes it easier to distinguish between different subcategories.
Example 3:
- Select the Category with Subcategory and sum as column and rows respectively.
- Select the chart type line graph.
- Drag and drop the market field in color to apply the marks that make it easier to distinguish between different markets.
- Click on the color and choose the marker type as a dot on lines for a better view.
Example 4:
- Select the Region and Category, Sales as column and rows respectively.
- Select the chart type line graph.
- Drag and drop the discount field in color to apply the marks that make it easier to distinguish between values of discount.
- Drag and drop the profit field in the label to apply the marks that make it easier to view the profit value.