Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tick mark labels | Charts and Charting in Excel | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
How do I eliminate duplicate values on y axis of an Excel chart? | Charts and Charting in Excel | |||
How do I break the value (Y) axis in an Excel chart ?? | Charts and Charting in Excel | |||
the dates to label the x axis on the scatter chart won't print | Charts and Charting in Excel |