+ Reply to Thread
Results 1 to 3 of 3

How to Plot a Bar Chart with FY and Quarters displaying on the Horizontal Axis in 2007

  1. #1
    Registered User
    Join Date
    10-18-2012
    Location
    Alabama
    MS-Off Ver
    2007
    Posts
    2

    How to Plot a Bar Chart with FY and Quarters displaying on the Horizontal Axis in 2007

    I am using Excel 2007. I have a stacked bar chart that I am using for a timeline for a project at work. The x-axis is the dates and the y-axis is the various tasks of the project. I want to use bar chart to show the time each company believes a milestone event will happen so I want the horizontal axis to look like “project” file with FY and Quarters displayed. I would really like to format it such that I have minor lines every quarter and major lines every month. Then I would like to put the name of the appropriate quarter between each major gridline.

    I am new to charting and can not find step by step instructions on how to do this.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-18-2012
    Location
    Alabama
    MS-Off Ver
    2007
    Posts
    2

    Re: How to Plot a Bar Chart with FY and Quarters displaying on the Horizontal Axis in 2007

    Still looking for a way to get Excel to draw this - anyone know how?

  3. #3
    Forum Contributor Steve N.'s Avatar
    Join Date
    12-22-2011
    Location
    USA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    298

    Re: How to Plot a Bar Chart with FY and Quarters displaying on the Horizontal Axis in 2007

    Based on what you've posted, a Gantt chart seems most appropriate. Look here for some great info on Gantt charts. http://peltiertech.com/Excel/Charts/ChartIndex.html#G

+ 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