| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Breaking X axis into sub units in a chart | Excel Discussion (Misc queries) | |||
| two units on primary Y axis | Charts and Charting in Excel | |||
| Change the X Axis units | Charts and Charting in Excel | |||
| Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel | |||
| Y axis, need varying units | Charts and Charting in Excel | |||
Linear Mode
