+ Reply to Thread
Results 1 to 2 of 2

When putting in X axis the data becomes distorted

  1. #1
    Forum Contributor
    Join Date
    06-11-2008
    MS-Off Ver
    2003
    Posts
    220

    When putting in X axis the data becomes distorted

    Hi,

    The chart on this attachment is correct except when I try and change the X axis to Week commencing and use the dates in cells C5:C25 it distorts the data in the chart. Any solutions anybody?!?
    Attached Files Attached Files
    Last edited by dandavis1; 11-28-2008 at 07:01 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,890
    Not really a distortion. When you use the dates for the axis labels excel plots the axis as time series.

    Although you are using dates you want the axis plotted as category.

    Right click chart and pick chart options.
    On the axis tab set X axis to Category rather than automatic.
    Cheers
    Andy
    www.andypope.info

+ 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