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

1. ## 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. ## 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

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

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

#### 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