Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.

Showing starting and ending time frame with 0s in a line chart

I'm creating line chart with a monthly time series from Jan 23 to current.  My series data does not contain any unties until May of 23 and then nothing starting in Jun 24.  I want to show 0s where there is no data to plot on the axis however nothing shows up on the x axis for the months of Jan-Apr. 23 and then again from Jun 24 to current.   There are several months however between May 23 and May 24 with no data and the 0s show up there.    How can I make sure the leading and ending months with no data show 0 on the axis?  Chart shown below.

TheresaM_0-1732222673186.png

 

0 2 86
2 REPLIES 2

@TheresaM 
What kind of chart are you using? Time series or line chart?
How exactly does your database look like?



@ArkadyZagdan   It is a time series chart and my data is in a spreadsheet.