graphing dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dw9050 - 23 Oct 2006 16:44 GMT

I'm trying to graph these dates;
9/1
9/5
9/6
But when I do this, 9/2, 9/3, and 9/4 are showing up on the chart. I don't
have data for these dates so I don't want to include them. Why is it
automatically entering??

Reply to this Message

Andy Pope - 23 Oct 2006 16:59 GMT

Hi,

The chart wizard is trying to be helpful by assuming you want a time
series axis for your dates. If you don't and you actually want just
categories then right click the chart and pick chart options...
On the axis tab set the scale to be category rather than automatic.

Cheers
Andy

> I'm trying to graph these dates;
> 9/1
[quoted text clipped - 3 lines]
> have data for these dates so I don't want to include them. Why is it
> automatically entering??

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

dw9050 - 23 Oct 2006 17:24 GMT

Thanks Andy!!

> Hi,
>
[quoted text clipped - 13 lines]
> > have data for these dates so I don't want to include them. Why is it
> > automatically entering??

Reply to this Message