Problem: Odd views in a stacked area chart with null values | Categorical X-axis for this graph crea

[rprible]

Problem: Odd views in a stacked area chart with null values | Categorical X-axis for this graph creates an X-axis that is too long.

Situation:

I have created a stacked area chart as shown below which works perfectly as shown:

This is currently shown with a Continuous X-axis:

However, when I filter my data, I may see results where some of the categories are periodically missing, where the results then look like the image below where lines are connected across the last time that "Team" was displayed, passing through times where "Team" was null and therefore creating an odd looking visual:

I have tried to correct this by:

A. Changing to "categorical" rather than "continuous" and while this works, my axis has too many elements and therefore not all 13 months can be viewed at the same time. This is not ideal as it no longer matches with the rest of my tables.

B. I have reordered my Ledgend but it did not remedy the results

C. I do not want to create 0s where I have no data for a particular activity type as this will nearly double my 500MB file.

Are there any solutions that shortens the X axis for Categorical labels in this view? Or any other options here?

[rprible · Accepted solution]

I found an acceptable solution for me - a stacked bar chart with a continuous X-axis! Sharing in case anyone else is looking!

[rprible]

@amitchandak I appreciate your response - unfourtunately, Categorical Axis is the solution to the odd view of my data. Seems I am stuck in a catch 22!

[amitchandak]

@rprible , As far as I know, Continuous Axis is the solution to reduce axis