View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
 
Posts: 553
Default 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