ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Can you change the intercept of the X-axis to a non-zero value? (https://www.excelbanter.com/charts-charting-excel/65517-can-you-change-intercept-x-axis-non-zero-value.html)

newaglish

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?

Bernard Liengme

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?





All times are GMT +1. The time now is 02:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com