+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    07-30-2009
    Location
    USA
    MS-Off Ver
    Excell 2007
    Posts
    2

    Unhappy Bar Graph Problems

    I keep trying to make a bar graph for some financial data. For some reason when I select the data, all the verticle bars lump together in the middle of the horizontal axis... How can I get them to spread out and use up the whole area?

    Also why cant you get lead lines on bar graphs like you can on pie charts?

    And lastly... if I want to do a 3 year spread on data in one bar graph.. I dont seem to be able to get it to go in the order I want.

    Id like it to go 2007 Category 1, 2008 Category 1, 2009 Category 1
    and then 2007 Category 2, 2008 Category 2, 2009 Category 2

    you get the idea... it keeps putting the years together and then the categories together and wont group them the way I want to.


  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,941

    Re: Bar Graph Problems

    most of your problems are probably related to your data layout.

    Can you post example workbook
    Cheers
    Andy
    www.andypope.info

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.2.0