Breaking X axis into sub units
 

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

--

Best Regards,
FARAZ A. QURESHI

Breaking X axis into sub units
 

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

"FARAZ QURESHI" wrote in message
...
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

--

Best Regards,
FARAZ A. QURESHI