Breaking X axis into sub units

[FARAZ QURESHI]

Following is simply an example of the source data of a chart with NPV
displayed on the X axis. I have several different combinations of such a
chart.

Any idea how to have every unit of 0.01 or 1% being automatically broken &
displayed in the chart, instead of inserting minor gridlines and counting the
same to determine a position between two points for example the exact
location at 7%?

NPV Savings Bank Deposit
0.00% 24,000 21,000
5.00% 13,016 10,204
10.00% 3,471 826
15.00% (4,877) (7,372)
20.00% (12,222) (14,583)

Thanx

 

[David Biddulph]

If you want to interpolate, do it in your data sheet, not on the chart. Try
the FORECAST function.