+ Reply to Thread
Results 1 to 2 of 2

Chart and date on X axis

  1. #1
    Registered User
    Join Date
    08-01-2008
    Location
    Portugal
    Posts
    1

    Chart and date on X axis

    Hey!!
    I’ve been having some troubles with Excel 2003 (SP2) chart.
    I’ve to do a chart which the x axis is date type data and in which the same date has several values. Even the date table has some gaps: 1st cell: 01-01-2006; 2nd:02-01-2006; 3rd: 13-01-2006; 4th: 14-01-2006, etc

    Now what is happening is if I just insert data on the Y axis and nothing on the X axis, I’ve got a completely different chart than if I add also the dates on the X axis.
    I need the chart result as the same without the dates on, but I do need to put them there.

    I’m using a standard chart type – the line.
    This is a sample of the data I’m using:

    75,6 01-01-2007
    0 01-01-2007
    0 02-01-2007
    9,4 03-01-2007
    102 03-01-2007
    37,8 03-01-2007
    0 15-01-2007
    (the bold number represents a different row from the date.)
    Usually which date has a correspondence of at least 30 values, and the average total cells are around 20000.

    Can you u help me up?. I’ve been fight this for a long time… I’m considering going for VBA programming
    Last edited by Saxjazz; 08-01-2008 at 11:29 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419
    Create the chart and then use Chart Options > Axis > Category.
    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