#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Charting dates

I am creating a graph in Excel 2007 where there are multiple dates on the X
axis. By default Excel groups duplicte dates togeather on the axis. You can
have them seperate as individual data points by formating the axis and
selecting "Text Axis" in Axis options.

Is there a way to this in Excel 2003?

Terry


  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Charting dates

Chart menu Chart Options Axes tab, change from Time Scale (or Automatic)
to Category.

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


"Terry" wrote in message
...
I am creating a graph in Excel 2007 where there are multiple dates on the X
axis. By default Excel groups duplicte dates togeather on the axis. You can
have them seperate as individual data points by formating the axis and
selecting "Text Axis" in Axis options.

Is there a way to this in Excel 2003?

Terry



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Charting dates

Thanx, works great
"Jon Peltier" wrote in message
...
Chart menu Chart Options Axes tab, change from Time Scale (or
Automatic) to Category.

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


"Terry" wrote in message
...
I am creating a graph in Excel 2007 where there are multiple dates on the
X axis. By default Excel groups duplicte dates togeather on the axis. You
can have them seperate as individual data points by formating the axis and
selecting "Text Axis" in Axis options.

Is there a way to this in Excel 2003?

Terry





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
reordering dates in worksheet for charting Wanda Excel Discussion (Misc queries) 0 April 3rd 07 07:04 PM
Graphing or charting dates tjsmags Charts and Charting in Excel 0 September 4th 06 02:47 PM
Charting dates on the Y axis without weekends JenTK2006 Charts and Charting in Excel 1 July 22nd 06 10:30 PM
Charting with dates changetires Charts and Charting in Excel 1 June 29th 06 09:55 PM
Charting data against dates where dates are not at fixed intervals PK Charts and Charting in Excel 4 June 16th 05 05:08 AM


All times are GMT +1. The time now is 08:57 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"