Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    May 2002
    Location
    Loveland, Ohio, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Graphing X-Axis Issue (Office 2002)

    I have a simple graph plotting two columns of data versus the date. Column one is a list of dates while columns 2 and 3 are the percentage values. I only have data for Monday through Friday, so my graphs have a strangeness that happens on the weekend (i.e., there are 3 days between the Friday and Monday points). Is there a way to remove the discontinuity and still maintain my date values?

    I know that I can remove column one, but I lose my date values. Thanks for any help you can provide!

    Andy

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Graphing X-Axis Issue (Office 2002)

    Make the X-Axis categories and not "dates"
    Right-click on chart
    Chart options - Axes tab
    Primary axis, Category(x) axis:
    select "Category" not automatic or time-scale

    The "X" will not longer be based on the dates, but only on the values actually listed in your column.

    Steve

  3. #3
    Star Lounger
    Join Date
    May 2002
    Location
    Loveland, Ohio, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graphing X-Axis Issue (Office 2002)

    Thanks Steve! That did it. A quote for Woody - "WOPR Lounge sure beat the Paper Clip ;-)

    Andy

Posting Permissions

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