Line chart to display all months Jan to Dec

[swarup_malli]

Hi,

I want my line chart to look like this ( see fig  the resulting chart should look like the chart at the bottom with all the months present.

[Anonymous]

Uncheck "suppress zero values" on the presentation tab in the chart properties.

[swarup_malli]

Thanks for the response Mike.

I already tried that, the problem with Uncheck "suppress zero values" is, it shows an  green line which I dont want as it misleads the business users  ( see the =attached app).is there a way to supress the green line ?

[swarup_malli · Accepted solution]

I was able to achieve the result by adding a expression that gave values for previous years,then unchecking all the options under the display options in expressions tab of the line chart properties.