Results 1 to 6 of 6

2-D 3-layer bar graph

Threaded View

tokyods 2-D 3-layer bar graph 04-14-2009, 11:52 PM
Andy Pope Re: 2-D 3-layer bar graph 04-15-2009, 04:53 AM
tokyods Re: 2-D 3-layer bar graph 04-15-2009, 12:41 PM
Andy Pope Re: 2-D 3-layer bar graph 04-16-2009, 07:23 AM
tokyods Re: 2-D 3-layer bar graph 04-17-2009, 01:11 AM
Andy Pope Re: 2-D 3-layer bar graph 04-17-2009, 05:24 AM
  1. #1
    Registered User
    Join Date
    04-14-2009
    Location
    Portland, Oregon
    MS-Off Ver
    Excel 2003
    Posts
    3

    2-D 3-layer bar graph

    I need to create a 2-dimensional bar graph with three layers:

    x-axis: months

    Rear layer: target (this will be the widest bar: overlap 100, gap 50, currently on primary axis)

    Middle layer: forecast (medium width: overlap 100, gap 220, currently first in order on secondary axis)

    Front layer: actuals (narrowest: overlap 100, also secondary axis, gap currently 220, but would like this to be the thinnest bar)

    I want to stack these one on top of the other with different widths so all are visible, but I when I adjust gap width, the middle and front layers change simultaneously (because they are on the same axis). That is, I can't set separate gaps to make sure they are both visible if they happen to have the same values. Example attached.

    Thanks for your help in advance.
    Attached Files Attached Files
    Last edited by Paul; 04-15-2009 at 12:06 AM. Reason: Thread moved to proper forum.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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