Customizing Axes
Get new perspectives on your data
In the same way you can customize the looks on your chart, you can also customize its different axes.
These are not aesthetic changes, though, as one can tell completely different stories by changing these settings.
Let’s review some of the common ones:
If the variable has a time component, the axis configuration will offer some options to aggregate data with
different “resolutions”. The smaller the time unit, the finer the visualization.
Particularly for dates, some semantically sensible options are given, such as grouping for each year,
week or quarters, among others.
If the X axis is numeric, binning options are offered based on the extent (minimum and maxium) the column
has. “Binning” means to break down the whole range of values in intervals, like chunks, and then seeing
how many rows lie in that interval. We can then make aggregations on each of these groups, like counting, averages, medians,
and such.
If the Y axis is numeric, aggregation options like average, median or standard deviation are offered for you to explore.
We can also sort these categories by some criteria, like the X axis metric, selection, ordinal or alphabetical order.
In general, this behavior is shared across the board, with some notable exceptions, like Box plots.
All particular cases are discussed in their corresponding page.
Axes configuration
Depending on the nature of the variable used for a given axis and the type of chart you are working with, some options will come up to help you shape the data and resulting visualization.Temporal Axis
Numeric X axis
Numeric Y axis
Categorical Axis
If the axis is categorical, we have two options to customize: We can limit the number of categories and choose only the “top” or “bottom” values for that category. This helps in reducing potential noise for categories that don’t have much relevance in your visualization.Number of rows
The option “number of rows” appears when you can have a sum up of a numeric value, like an average, sum or median. With the number of rows, some options arise that are particularly interesting when searching for patterns. This can all be expressed as relative comparisons between categorical values. The most common, and default one, is the count, where we literally express the number of rows. But other operations can be made.Relative Count (All)
This method changes the scale to percentage, where now, instead of showing how many rows fall into these categories, we show the percentage of rows. In this example, we can see the proportion of gender in each age bracket. The left-most blue bar indicates that there are ~89.6 transactions made by 18 – 24 years old women, which corresponds to 5.56% of the whole dataset.These charts are interactive, use your mouse to explore!