How do I get a chart to only display the dates in my table?
 

I am trying to graph a large group of data. It is a series of dates (not all
consecutive) - with the time it takes to do a task on each of the dates.
When I graph it - it fills in all the "missing" dates. For instance lets say
a set of data would be:
Date: 12-1-08 12-5-08 12-6-08 12-6-08 12-12-08
Time: .5 .34 .93 1.2 .25

On my graph it would put a date for every date between 12-1 and 12-12 even
if there is no data. Is there any way to have Excel graph only the dates
that have data?

How do I get a chart to only display the dates in my table?
 

Change the axis from the default date-scale that Excel applies when it sees
dates, to a plain category type. In Excel 2003 & earlier, go to Chart menu
Chart Options Axes tab, and choose Category for X Axis. In Excel 2007,
right click the axis, choose Format, and on the first tab, change the axis
type to Text. I don't recall exactly what they've renamed it, but it has the
word "Text" in it, and the matching option has the word "Date" in it.

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


"Kathi" wrote in message
...
I am trying to graph a large group of data. It is a series of dates (not
all
consecutive) - with the time it takes to do a task on each of the dates.
When I graph it - it fills in all the "missing" dates. For instance lets
say
a set of data would be:
Date: 12-1-08 12-5-08 12-6-08 12-6-08 12-12-08
Time: .5 .34 .93 1.2
.25

On my graph it would put a date for every date between 12-1 and 12-12 even
if there is no data. Is there any way to have Excel graph only the dates
that have data?