+ Reply to Thread
Results 1 to 3 of 3

2D Bar Chart - Date X axis

  1. #1
    Registered User
    Join Date
    11-13-2014
    Location
    London
    MS-Off Ver
    10
    Posts
    2

    Post 2D Bar Chart - Date X axis

    Hi All,

    I have been trying to create a high-level project plan that shows the duration of tasks(horizontally) and the date per month on tasks on the x axis

    The trouble I am having is that on my x axis I cannot seem to get the axis to be date based and I am really struggling to see why. It would be great if I could do this as then I would be able to achieve consistent monthly dates across the bottom i.e 1st Nov, 1st Dec, 1st Jan etc

    Start Duration
    "Requirements Gathering" 10 November 2014 18
    "Test Environment Creation" 10 November 2014 11
    "Data Cleanse" 01 December 2014 11
    Test System Configuration 12 December 2014 35

    I have literally searched everywhere for an answer to no avail, and my date column is in date format

    Please help

    Thank John

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: 2D Bar Chart - Date X axis

    The value axis on a bar chart is purely values.
    In order to have a data axis it needs to be the category axis that is formatted.

    So to get a category axis you can add a dummy series, move it to the secondary axis and change the chart type.
    Once on the secondary axis add a secondary vertical axis and format as required.

    Attached includes screen shots of the various axis format dialogs so you can see the date opition.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    11-13-2014
    Location
    London
    MS-Off Ver
    10
    Posts
    2

    Re: 2D Bar Chart - Date X axis

    Thank you very much Andy

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] chart date axis
    By ProtoVB in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-27-2014, 06:32 AM
  2. Excel 2007 : How to set the date as x-axis in a chart
    By JustinNY in forum Excel General
    Replies: 1
    Last Post: 09-22-2011, 02:46 PM
  3. Chart and date on X axis
    By Saxjazz in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-11-2008, 09:21 AM
  4. [SOLVED] how to draw a chart using x,y axis not the date with x-axis?
    By elshohna in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-12-2005, 08:25 AM
  5. Chart - date axis
    By aparso in forum Excel General
    Replies: 0
    Last Post: 01-10-2005, 05:27 AM

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