Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting Y axis Hassan Charts and Charting in Excel 1 May 20th 08 04:15 PM
Setting Y axis as time Bethoc Charts and Charting in Excel 1 February 27th 08 04:03 AM
secondary axis - setting -VBA graham_s Charts and Charting in Excel 1 November 2nd 07 08:58 AM
setting x-axis labels lschuh Charts and Charting in Excel 2 October 21st 05 01:27 PM
SETTING AXIS TITLE matt a Charts and Charting in Excel 1 April 15th 05 03:50 PM


All times are GMT +1. The time now is 04:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"