Data Chart Help

[leapyearbaby]

Hi,

Hopefully someone can help with my question. I am creating a chart in Excel. The data from the chart will be based on a selected range (ex. A1:G1). Not every cell will always have data. How do I set it up so that the times where no data is entered, it does not default to $0, which then changes the values of the Y-axis to start at 0.

Thank you!

 

[PCL]

Instead to have empty cells fill them with

#N/A