Some spreadsheet data is not appearing on chart/graph

[JulieKeeble]

sales.docx

Please Login or Register  to view this content.

If you look at columns D and E on the spreadsheet, these are not appearing on the chart/graph. Can anyone help as I cannot see why.
Many thanks
Julie

[Glenn Kennedy]

Replace the empty spaces in your data with =NA() That should make the difference you want...

[JulieKeeble]

Thank you so much Glenn, I hadn't thought of that, it's done the trick. I've been trying to figure it out all morning.