ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Negative values on X axis (https://www.excelbanter.com/charts-charting-excel/453142-negative-values-x-axis.html)

[email protected]

Negative values on X axis
 
Hello,

I am creating a line graph, and need the X axis to go as such: -4,-3,-2,-1,0,1,2,3,4.

Whenever I try to change the axis to negative, all numbers become negative. How can I properly format my graph?

Claus Busch

Negative values on X axis
 
Hi,

Am Tue, 14 Feb 2017 09:15:14 -0800 (PST) schrieb :

I am creating a line graph, and need the X axis to go as such: -4,-3,-2,-1,0,1,2,3,4.

Whenever I try to change the axis to negative, all numbers become negative. How can I properly format my graph?


right click on the x axis = Format axis = Minimum:-4, Maximum:4
If it doesn't work, show us your workbook.


Regards
Claus B.
--
Windows10
Office 2016


All times are GMT +1. The time now is 09:08 AM.

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