+ Reply to Thread
Results 1 to 3 of 3

Excluding weekends and holidays from chart

  1. #1
    Forum Contributor
    Join Date
    09-09-2009
    Location
    Columbus. Ohio
    MS-Off Ver
    Excel 2000
    Posts
    199

    Excluding weekends and holidays from chart

    I am making a chart to track stock quotes over a set peroid of time (last 7 quotes). I am able to get the information I want in the cells but when I apply the data to a chart and list the days the chart wants to fill in all dates, including weekends and hollidays.
    Attached is a sample of the worksheet.

    JIm O
    Attached Files Attached Files
    Last edited by Jogier505; 12-07-2010 at 04:42 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,703

    Re: Excluding weekends and holidays from chart

    See attached.

    To fix it yourself, right-click on the X-axis, and select Format Axis. Under Axis Options, under Axis Type, select Text. You allowed it to default to Automatic, which detects the dates and makes it a time series.

    With options as set, you will see only those dates that explicitly appear in the data.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    09-09-2009
    Location
    Columbus. Ohio
    MS-Off Ver
    Excel 2000
    Posts
    199

    Re: Excluding weekends and holidays from chart

    That was something I was not aware of, thank you very much!

    Jim O

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1