How to do it…

  1. If you are in edit mode, click on Done.
  2. Hover your mouse over the Treemap object.
  3. Click the Sliders button at the top-right of the visualization, or right-click on the visualization and select Open Exploration menu.
  1. Open the Presentation section and set on in the Value labels property.
  2. The result should resemble the following screenshot:

  1. The value labels are shown on each block.
  2. Click on Close full screen to close the menu and go back to visualization mode.
  3. Now, go to the sheet with the bar chart created in the last recipe.
  4. Open the visual exploration menu for the bar chart.
  5. Open the Sorting section.
  6. Select the measure on the second line and drag it over to the first line to change the sorting criteria to by measure.
  7. Click the arrow on the left of the measure to open the sorting property and select Descending.
  1. The result should resemble the following screenshot:

  1. Click on Close full screen to close the menu and go back to visualization mode.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset