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.

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" wrote in
message ...
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.