What is a category or measure axis?

What is a category axis or a measure axis?

The category axis is the axis that your data is organized by. The measure axis is where the values are placed.

How do I determine which data series belongs into the category or measure axis?

If your data relies on a specific data series to organize itself, then it is likely a category data series and it belongs in the category axis. For example, if you have data on the national live football game attendance for 2010 across males and females, you will have one data series for gender and another data series for attendance. This means that the attendance data relies on the gender breakdown. Gender, hence, is a category data series and should be placed into the category axis. Category-axis candidates are typically text in format. One instance where they would be numerical is when the category is expressed as years (1988, 1989, etc); while they are numerical, your corresponding data is organized by these leading categories.

The attendance data are numerical values that measure how many males and how many females attended a live game. The attendance data is a measure data series and should be placed in the measure axis.

Is the category or the measure axis typically the horizontal or vertical axis?

Whether or not your category axis will be in the horizontal or vertial axis depends entirely on the chart type you are using. Your category axis will be the horizontal axis if you are using a column chart, 100% stacked column chart, stacked column, line chart, area chart or combo chart.

Your category axis will be the vertical axis if you are using a bar chart, 100% stacked bar chart, stacked bar or vertical line chart.