ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   x-axis value setting (https://www.excelbanter.com/charts-charting-excel/212402-x-axis-value-setting.html)

krystle

x-axis value setting
 
Does anyone know how to set the x-axis as a category axis so that it will
only display the range inputted? I am trying to graph dates -14, 0, 2, 4, 6
days and I don't want the large gap from -14 to 0. Is there anyway to
eliminate this?

Jon Peltier

x-axis value setting
 
Create a line chart, not an XY chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"krystle" wrote in message
...
Does anyone know how to set the x-axis as a category axis so that it will
only display the range inputted? I am trying to graph dates -14, 0, 2, 4,
6
days and I don't want the large gap from -14 to 0. Is there anyway to
eliminate this?





All times are GMT +1. The time now is 09:53 PM.

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