Excel Charts ignoring Zeros

New Contributor

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 March and some December.

Is there a way of producing a line chart which would plot this 

Sample data 

Dec-16Mar-17Dec-17Mar-18Dec-18Mar-19Dec-19Mar-20Dec-20Mar-21
251.7 284.5 243.3 244.9 305.9 
102.5 102.0 98.0 102.4 92.3 
 102 153 89 250 124

 

I was hoping to produce something along the lines of

 

Jude_ward1812_0-1637488743458.png

 

but using the chart function line graphs appear to not show any information

 

Sorry its probably a very simple answer i have missed

Thanks in advance

 

 

 

2 Replies

@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