How to exclude weekends/holidays from plotted time series

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 Chart>Options
Select the Axes tab
For Category (X) axis, choose Category, click OK
 
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.
 
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/
_______
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XY Charts Excluding Weekends 1
Convert Error Bars to Series and Colour 1
xy scatter graph 0
Charting only the dates shown 1
Date range on chart includes dates not on worksheet 3
How to change series plotting order without changing legend order? 6
Help with "clusters" of plotted data 2
XY scatter plot with more than 32000 rows in Excel 2003 0

Back
Top