If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
label the category axis from 0 to 30, step 5 in an excel chart
My excel chart is a graph of Interest's share and Principal's share of each
Monthly Payment of the 360 payments of a 30-year mortgage. It's a nice continuous graph that shows the point where Principal's share becomes dominant (at 18.5 years). All i've wanted to do these past three days is have an x-axis labeled with tick marks starting at 0, ending nicely at exactly 30 , and with the tick marks 5,10, 15, 20 and 25 in between. Why is this so difficult a challenge? Why did i have to buy that $25.00 dummies book and still not find the answer? Thanks for the help. |
#2
|
|||
|
|||
label the category axis from 0 to 30, step 5 in an excel chart
Right click the x-axis; menu pops up; click on Format Axis
In dialog box, click Scale tab, replace the Man and Max and tick setting by what you want DO NOT have a check mark in the Auto boxes And it that does not work come back for more. -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "johnny hanlon" johnny hanlon @discussions.microsoft.com wrote in message ... My excel chart is a graph of Interest's share and Principal's share of each Monthly Payment of the 360 payments of a 30-year mortgage. It's a nice continuous graph that shows the point where Principal's share becomes dominant (at 18.5 years). All i've wanted to do these past three days is have an x-axis labeled with tick marks starting at 0, ending nicely at exactly 30 , and with the tick marks 5,10, 15, 20 and 25 in between. Why is this so difficult a challenge? Why did i have to buy that $25.00 dummies book and still not find the answer? Thanks for the help. |
#3
|
|||
|
|||
label the category axis from 0 to 30, step 5 in an excel chart
Bernard forgot to remind you to make an XY chart, not a Line chart.
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Bernard Liengme" wrote in message ... Right click the x-axis; menu pops up; click on Format Axis In dialog box, click Scale tab, replace the Man and Max and tick setting by what you want DO NOT have a check mark in the Auto boxes And it that does not work come back for more. -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "johnny hanlon" johnny hanlon @discussions.microsoft.com wrote in message ... My excel chart is a graph of Interest's share and Principal's share of each Monthly Payment of the 360 payments of a 30-year mortgage. It's a nice continuous graph that shows the point where Principal's share becomes dominant (at 18.5 years). All i've wanted to do these past three days is have an x-axis labeled with tick marks starting at 0, ending nicely at exactly 30 , and with the tick marks 5,10, 15, 20 and 25 in between. Why is this so difficult a challenge? Why did i have to buy that $25.00 dummies book and still not find the answer? Thanks for the help. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Category Labels(X) axis on a chart: | Ali | Worksheet Functions | 2 | January 19th, 2006 11:53 AM |
replace axis text with graphics on excel chart (excel 2003) | Mad_Hatter_29 | Charts and Charting | 3 | December 6th, 2005 01:42 PM |
Text Truncated on Vertical Chart Axis Label | Adrian | General Discussion | 1 | October 20th, 2005 11:50 AM |
Combined bar and line chart (two Y axis) how to make excel know which data goes where | Bugjam1999 | Charts and Charting | 2 | September 22nd, 2005 11:57 AM |
Dynamic Bar Chart Category Axis Problem | Richard | Charts and Charting | 1 | September 13th, 2005 09:51 AM |