I have a line chart spanning an entire year of days, and I’d like to break some (but not all) lines up into months by manually splitting the lines at specific points. Is there a way to do this short of re-arranging my data table entirely? Currently running 7.3.2.2.
With the Line chart type:
-
At the bottom of your data, add the dates (repeated dates), one for each split; (for one year 11 it’s ok, for there’s no need of a split after december).
-
Leave empty the cells in the value column.
-
Edit your chart Data Ranges (
Data Seriestab), and extend the reference at Range for Y-Values and Categories.
-
Edit the Data serie, and select Leave gap.
1 Like
Worked like a charm!
1 Like