Results 1 to 2 of 2
  1. #1

    How to plot dates

    I have a spreadsheet with three columns and five rows. the columns are named "Phase", "Start date", and "Stop date". In the rows are phases (like research, plan, etc) and dates - both start and stop.

    I can't figure out how to get a horizontal bar chart that will have phases on the Y axis, dates on the X axis, and bars in the plot area that begin and end on the appropriate dates (or as close as can be graphically represented, depending on scale).

    Is there a way to do this?



  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Dublin, Ireland, Republic of
    Thanked 0 Times in 0 Posts

    Re: How to plot dates

    A Gannt chart might meet your requirements but Excel does not directly support them. Read through This Thread for some leads as to how you might achieve what you want.

    Andrew C

Posting Permissions

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