+ Reply to Thread
Results 1 to 2 of 2

Graphing-Two stacked columns side-by-side per year

  1. #1
    brwneyeirishlady
    Guest

    Graphing-Two stacked columns side-by-side per year

    Graphing in Excel - I have six years worth of data. The 'Fiscal year' is
    along the x-axis, and 'Dollars' is on the y-axis. There are two sets of data
    (with three dollar amounts)for each year. The first is for the corporation
    overall, and the second is for one business unit within the corporation. I
    want to display two stacked columns side-by-side within each fiscal year. How
    do I do this?

    Excel keeps trying to stack the six into one column per fiscal year. Here
    is a depiction of what I am trying to do:

    A X A X A X A X
    B Y B Y B Y B Y
    C Z C Y C Y C Y
    Year 1 Year 2 Year 3 Year 4

    ABC is the stacked data for the corporation. And XYZ is the stacked data
    for one of the business units within the corporation.




  2. #2
    Bernard Liengme
    Guest

    Re: Graphing-Two stacked columns side-by-side per year

    see http://people.stfx.ca/bliengme/ExcelTips/Columns.htm
    best wishes
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "brwneyeirishlady" <brwneyeirishlady@discussions.microsoft.com> wrote in
    message news:44915F53-4980-4DDD-9F83-882596E8D383@microsoft.com...
    > Graphing in Excel - I have six years worth of data. The 'Fiscal year' is
    > along the x-axis, and 'Dollars' is on the y-axis. There are two sets of
    > data
    > (with three dollar amounts)for each year. The first is for the
    > corporation
    > overall, and the second is for one business unit within the corporation.
    > I
    > want to display two stacked columns side-by-side within each fiscal year.
    > How
    > do I do this?
    >
    > Excel keeps trying to stack the six into one column per fiscal year. Here
    > is a depiction of what I am trying to do:
    >
    > A X A X A X A X
    > B Y B Y B Y B Y
    > C Z C Y C Y C Y
    > Year 1 Year 2 Year 3 Year 4
    >
    > ABC is the stacked data for the corporation. And XYZ is the stacked data
    > for one of the business units within the corporation.
    >
    >
    >




+ 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