Last Modified Date: 14 Sep 2017
AnswerGraph the bars on a continuous axis of the running sum of the measure used on Size to define the width of the bars.
The attached example workbook uses the sample data set Superstore to demonstrate the following directions:
- Drag [City] to the Filters shelf
- In the Filter dialog, check only "Austin" and click OK.
- Drag [Sales] to the Rows shelf
- Drag [Customer Name] to Label on the marks card
- Drag [Quantity] to Size on the marks card
- Drag [Quantity] to the Columns shelf
- Right-click SUM(Quantity) on the Columns shelf and select Quick Table Calculation > Running Total
- Right-click SUM(Quantity) on the Columns shelf and select Compute Using > Customer Name
- On the marks card, in the mark type dropdown select Bar
- Click Size, and do the following:
- Select Fixed
- For Alignment, select Right
- Right-click [Customer Name] on Label and select Sort…
- In the Sort dialog, so the following and click OK:
- For Sort by, select Field
- In the dropdown menu, select Sales
- Right-click SUM(Quantity) on the Columns shelf and uncheck Show Header.
Additional InformationOnly a continuous axis will allow the bars to touch.
An additional example of such a chart can be found in the following article: Creating a Skyline Chart (Variable Width Column Chart)
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials