Forum Discussion
Excel Charts ignoring Zeros
Hi All I am trying to produce a line chart for financial results for different organisations as part of a project unfortunately not all the organisations have the same month as year end, some Ma...
Jude_ward1812 The default setting is to show hidden and empty cells as gaps. change it to "Connect data points with a line" On the Chart Design ribbon, Select Data.
See attached.
- thank you that's a great help
Jude
