| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can you change the intercept of the X-axis to a non-zero value?
Mathematically it sounds stupid, but anyway:
I have a simple time series plotting economic growth rates against time. In 1998 the growth rate for the country in question is negative, so the line graph drops below the X-axis, to -6.7%. The X-axis now goes straight through the graph, which is pretty unsightly. Is there a way I could move the X-axis down to Y=-8% for example? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Can you change the intercept of the X-axis to a non-zero value?
Format the axis and change the value of Crossing At
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "newaglish" wrote in message ... Mathematically it sounds stupid, but anyway: I have a simple time series plotting economic growth rates against time. In 1998 the growth rate for the country in question is negative, so the line graph drops below the X-axis, to -6.7%. The X-axis now goes straight through the graph, which is pretty unsightly. Is there a way I could move the X-axis down to Y=-8% for example? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the "Y" axis information in a chart | Charts and Charting in Excel | |||
| Different Secondary X Axis but same Y Axis | Charts and Charting in Excel | |||
| Chaning X axis scale in Excel 2003 | Charts and Charting in Excel | |||
| can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
| How can I change typesetting (spacing, etc.) of bar chart axis lab | Charts and Charting in Excel | |||
Hybrid Mode
