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
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.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |