Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / July 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
brwneyeirishlady - 30 Jul 2006 19:46 GMT
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.
Bernard Liengme - 30 Jul 2006 20:18 GMT
see http://people.stfx.ca/bliengme/ExcelTips/Columns.htm
best wishes
Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> 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
[quoted text clipped - 17 lines]
> ABC is the stacked data for the corporation.  And XYZ is the stacked data
> for one of the business units within the corporation.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.