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

  • Thread starter Thread starter Kathi
  • Start date Start date
K

Kathi

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?
 
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
 
Back
Top