Charting Dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sam - 07 Nov 2003 02:54 GMT

I am making a chart using data from a worksheet that
includes only weekday dates, however, when I make the
chart using that source material, Excel automatically
adds in weekend dates. I do not want the weekends to be
included. How do I get them out of the chart?

Reply to this Message

Jon Peltier - 07 Nov 2003 04:36 GMT

Sam -

You have a time scale category axis. To convert it to a category
category axis: right click the chart, select Chart Options from the pop
up menu, click on the Axes tab, and under Category (X) Axis, select
Category.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

> I am making a chart using data from a worksheet that
> includes only weekday dates, however, when I make the
> chart using that source material, Excel automatically
> adds in weekend dates. I do not want the weekends to be
> included. How do I get them out of the chart?

Reply to this Message

sam - 09 Nov 2003 18:47 GMT

Thank you! That worked perfectly.

>-----Original Message-----
>Sam -
[quoted text clipped - 17 lines]
>
>.

Reply to this Message