Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Variable Dates in Graph Scale

I need to create a graph with Dates on the X axis as follows:
2/7/08
3/31/08
6/30/08
9/30/08
12/31/08

I can get dates for 12/31/07, 3/31/08, 6/30/08, 9/30/08, 12/31/08 to show if
I select 3 months as the scale on the X-axis, but I don't want 12/31/07 -- I
want 2/7/08 as my beginning date. How do I show 2/7/08 and then the
remaining quarter-ending dates?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default Variable Dates in Graph Scale

Excel doesn't provide that fine control over axis scales. Me, I'd just keep
12/31/07, but I suppose you could make a dummy axis and add data labels to
show the desired dates:

http://peltiertech.com/Excel/Charts/...tml#AxisScales

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"CParker" wrote in message
...
I need to create a graph with Dates on the X axis as follows:
2/7/08
3/31/08
6/30/08
9/30/08
12/31/08

I can get dates for 12/31/07, 3/31/08, 6/30/08, 9/30/08, 12/31/08 to show
if
I select 3 months as the scale on the X-axis, but I don't want 12/31/07 --
I
want 2/7/08 as my beginning date. How do I show 2/7/08 and then the
remaining quarter-ending dates?



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
Scale on line graph EasySite Charts and Charting in Excel 1 April 18th 07 02:39 PM
changing the scale on the graph maryam Charts and Charting in Excel 3 January 22nd 07 01:51 AM
Radar Chart with Variable X Scale Taryn Charts and Charting in Excel 8 August 3rd 05 03:17 PM
Graph on Inverted Scale Deepak Thakkar Charts and Charting in Excel 2 July 26th 05 08:04 AM
Setting x axis scale to time with variable intervals webbuzzard Charts and Charting in Excel 1 June 27th 05 07:13 PM


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

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"