Breaking X axis into sub units in a chart
 

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 in a chart
 

Use an XY chart, not a line chart. On the format X axis dialog, scale tab,
set the major unit to 1%.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"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