+ Reply to Thread
Results 1 to 5 of 5

Floating Bars

  1. #1
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    585

    Floating Bars

    Hello all,


    So far I managed [with a lot of help from Andy Pope] to create a graph like the one below [without the orange bars]
    The graph is self-explanatory as all values are given on top.

    Now I'm looking for way to place orange bars like the one in the image below.
    The orange bars should be placed adjacent to the gray one based on the values given in collumn P.

    If this is possible what about placing them in front of the grey one. Even better still, in some cases I would like to place 2 extra bars, 1 in front and one at the end.

    [the orange bars on the image below are custom shapes]
    graph.jpg
    Attached Files Attached Files
    Last edited by Jonathan78; 10-04-2009 at 01:22 PM.

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

    Re: Floating Bars

    You just need to add a series either side of the Grey one.
    The values will need to be gather from some where and new Dynamic named ranges added.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    585

    Re: Floating Bars

    Thanks Andy, that is what I was lloking for.
    I tried to make dynamic ranges of it, but donīt get it working.

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

    Re: Floating Bars

    Just create 2 new named ranges similar to ExportFlightvals,

    =OFFSET(ImportFlightvals,0,6)

    And change the 6 so the correct column is selected.

    LEFTORANGE: =OFFSET(ImportFlightvals,0,17)
    RIGHTORANGE: =OFFSET(ImportFlightvals,0,19)

  5. #5
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    585

    Re: Floating Bars

    Thanks Andy,
    You reall helped me out with this

+ 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