The horizontal lines are flattened box plots, which is what happens when box plots are based on a single mark.īox plots are intended to show a distribution of data, and that can be difficult when data is aggregated, as in the current view. We'll change that.ĭrag Region from the Marks card back to Columns, to the right of Segment. It determined that the marks should represent regions. When you changed the chart type to a box plot, Tableau determined what the individual marks in the plot should represent. Also, Tableau reassigned Region from the Columns shelf to the Marks card.
Notice that there are only a few marks in each box plot. Now you have a two-level hierarchy of dimensions from left to right in the view, with regions (listed along the bottom) nested within segments (listed across the top).Ĭlick Show Me in the toolbar, then select the box-and-whisker plot chart type. Tableau creates a vertical axis and displays a bar chart-the default chart type when there is a dimension on the Columns shelf and a measure on the Rows shelf.ĭrag the Region dimension to Columns, and drop it to the right of Segment. To create a box plot that shows discounts by region and customer segment, follow these steps:Ĭonnect to the Sample - Superstore data source.
#Box and whisker plot excel for mac how to#
The basic building blocks for a box and whisker plot are as follows:įor information on how to add a reference line, see Reference Lines, Bands, Distributions, and Boxes (Link opens in a new window).
0 kommentar(er)
