+ Reply to Thread
Results 1 to 5 of 5

Changing chart column width to represent time in excel

  1. #1
    Registered User
    Join Date
    12-06-2012
    Location
    SOuth Yorkshire
    MS-Off Ver
    Excel 2010
    Posts
    3

    Changing chart column width to represent time in excel

    I need to show money coming from various sources (shown as stacked column chart) that are coming in over different time periods.

    I want to show the money coming in
    in next three months (as one stacked coloum)
    in months 4-12 (as another stacked column but 3 times wider than first )
    in months 13-24 ( as another stacked column but 4 times wider than the first)

    I dont seem to be able to find a solution and i would be so appreciative to anyone who can help, this is stretching my excl skills to the limit.

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

    Re: Changing chart column width to represent time in excel

    Can you attach a sample file of the data you're trying to chart?

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

    Re: Changing chart column width to represent time in excel

    Something like this maybe
    http://www.andypope.info/charts/colwidth2.htm
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    12-06-2012
    Location
    SOuth Yorkshire
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Changing chart column width to represent time in excel

    In will try and attach an exmaple,

    I have looked at the example and im afraid to say it assumes my knoweldge is better than what it is, the directions are not simple enough for me.

    I need to be able to show the income as stacked so i can identify if one source is going to be crucial to survival.

    I erally appreciate your help

  5. #5
    Registered User
    Join Date
    12-06-2012
    Location
    SOuth Yorkshire
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Changing chart column width to represent time in excel

    column width.jpg

    I could not get it to attach my excel but i could get it to upload a screen print.

    Still very confused it seems that it should be simple

+ 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