I have a chart that displays a set of measurements taken over a few months. There are long periods when no measurements were taken. I want to omit these in the chart. I’ve attached a simple example of what I’m trying to do
ChartRanges.ods (18.2 KB)
In this sample spreadsheet there are a set of measurements from 1-4 January, then from 28 January to 5 February. I want the x axis to display 1,2,3,4 January then 28,29… I don’t want 5-27 January when there were no measurements.
In this chart, I set the data range to $Sheet1.$A$1:$B$4,$Sheet1.$A$6:$B$10, hoping this might omit the missing dates, but it doesn’t.
Is there any way to display disjoint intervals along the x axis?