Breaking X axis into sub units

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FARAZ QURESHI - 16 Apr 2008 11:27 GMT

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

Signature

Best Regards,
FARAZ A. QURESHI

Reply to this Message

David Biddulph - 16 Apr 2008 16:26 GMT

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

Signature

David Biddulph

> 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
[quoted text clipped - 14 lines]
>
> Thanx

Reply to this Message