ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Charting dates (https://www.excelbanter.com/charts-charting-excel/213913-charting-dates.html)

Terry

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



Jon Peltier

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




Terry

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







All times are GMT +1. The time now is 10:34 PM.

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