Add Axis Labels In Excel Mac 2011 I

Working with Excel for Mac 2011 I have a certain graph of a curve, say a yield curve.

Suppose there are values on the x-axis that are 0.10 apart.

Now, there are certain values on this graph I want highlighted, if they equal a certain value.

The problem is, they almost always will have a x-axis value somewhere between the x-axis values.

Because that value comes from a calculation, not the datatable.

So example, I have data points (4.5, 6) and (4.6, 9).

The required highlighted y-value in this case could be 7, at x-value 4.533.

Does anyone know how I can add this 7 value to the graph And I do not want to change the scale of the x-axis.

Add Axis Labels In Excel Series But Then

I tried making a new series but then that did not work because of the different x-axis labels.

I can not just re-sort the sequenced values (values at 4.5, 4.6, 4.7, etc.) including the calculated values because the latter do not come from the data table.

In practice, these left and right values will change periodically.

Additionally, I would like to add a dashed vertical line for the current value.

Hopefully you could shed some light, your help is much appreciated.

How To Add Axis Labels In Excel For Mac