Graphing Y-axis with log scale in excel 2016

Question

Hi,

I need to plot the following dataset with Y-axis in log scale. Only interested to plot the data between 3500-3600 range. Large data represents error therefore can be omitted. I am having problem defining the axis to plot the data. Any help is highly appreciated. 

X Y

5/1/2016 3550

9/2/2016 3555

9/3/2016 99999

9/4/2016 3550

11/5/2016 3540

11/6/2016 3541

11/7/2016 -99999

11/8/2016 3542

9/9/2016 3560

9/10/2016 3556

1/11/2017 3560

1/12/2017 99999

1/13/2017 3555

3/14/2016 3540

3/15/2016 -99999

3/16/2016 3545

5/17/2016 3560

Answer 1

Because the dates (X column) are not in order, I made a Line chart not an XY chart

Formula in B2 is =IF(AND(D2>0,D2<4000),D2,NA())

The label 3600 on the y-axis is a text box

But why a log axis? Second screenshot is not logarithmic

best wishes

Answer 2

I have data for more than one sample point. Plotting them in one chart does not clearly show the trend for some sample points (blue and pink data below). I think the log scale can be of help and show the trend as shown for blue line below.