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.
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
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 Chart>Options
> 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 Chart>Options
>>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
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks