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?