How to exclude weekends/holidays from plotted time series
 

Excel is inserting holidays and weekend days into my time series. I want to
stop it doing this and to use only my date series.

The x-axis has defaulted to a time-scale. To change the setting:

Select the chart
Choose ChartOptions
Select the Axes tab
For Category (X) axis, choose Category, click OK


Debbie424242 wrote:
Excel is inserting holidays and weekend days into my time series. I want to
stop it doing this and to use only my date series.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks - this enables me to plot the data without discontinuities, but I lose
my date formatting. The data I am using is imported from a newswire service,
so the trading dates get converted to the corresponding numbers when I change
the x-axis to category.

"Debra Dalgleish" wrote:

The x-axis has defaulted to a time-scale. To change the setting:

Select the chart
Choose ChartOptions
Select the Axes tab
For Category (X) axis, choose Category, click OK


Debbie424242 wrote:
Excel is inserting holidays and weekend days into my time series. I want to
stop it doing this and to use only my date series.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Debbie -

You can still use a number format. DOuble click the axis, select the Number tab, and
choose a date format you like.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Debbie424242 wrote:

Thanks - this enables me to plot the data without discontinuities, but I lose
my date formatting. The data I am using is imported from a newswire service,
so the trading dates get converted to the corresponding numbers when I change
the x-axis to category.

"Debra Dalgleish" wrote:


The x-axis has defaulted to a time-scale. To change the setting:

Select the chart
Choose ChartOptions
Select the Axes tab
For Category (X) axis, choose Category, click OK


Debbie424242 wrote:

Excel is inserting holidays and weekend days into my time series. I want to
stop it doing this and to use only my date series.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html