Skip to content

hierarchy axis

step 1:

  • select chart type

  • set axis data: year and quarter

  • set legend data: region

  • set value data: Sales step 2:

  • set x-axis as category

  • turn off concatenate labels: format pane -> X axis -> turn off concatenate labels

  • make sure sort order should be ascending, click on ellipsis icon (three dots in the figure up-right corner) -> Sort ascending