Results 1 to 2 of 2

Stacked Column Chart from Multiple Data Points

This is a discussion on Stacked Column Chart from Multiple Data Points within the Excel Questions forums, part of the Question Forums category; I have the following data that I would like to put into a stacked bar graph. Q1 2012 Q2 2012 ...

  1. #1
    Board Regular
    Join Date
    Oct 2008
    Location
    Utah
    Posts
    123

    Default Stacked Column Chart from Multiple Data Points

    I have the following data that I would like to put into a stacked bar graph.

    Q1 2012 Q2 2012 Q3 2012 Q4 2012
    Yes No N/A Yes No N/A Yes No N/A Yes No N/A
    Question #1 50% 0% 50% 18% 2% 80% 17% 3% 80% 100% 0% 0%
    Question #2 47% 7% 46% 38% 2% 60% 22% 8% 70% 47% 3% 50%
    Question #3 41% 18% 41% 22% 18% 60% 42% 18% 40% 45% 15% 40%
    Question #4 34% 33% 33% 64% 33% 3% 38% 22% 40% 90% 0% 10%

    I would like the stacked bar graph to show the stacked graph for Question 1 next to the stacked graph for Question 2 (and so on) for Q1, then the stacked graph for the questions for Q2, and so on and so forth. So far, I cannot find a way to make that happen. Any suggestions?

  2. #2
    Board Regular pbornemeier's Avatar
    Join Date
    May 2005
    Location
    Virginia Beach, VA USA
    Posts
    3,294

    Default Re: Stacked Column Chart from Multiple Data Points

    When I put your data in to Excel I get a graph that seems to be as you described.

    Perhaps you want clustered & stacked graphs, the procedure for creating them is discussed here:
    Clustered and Stacked Column and Bar Charts | Peltier Tech Blog | Excel Charts
    Phil

    - Use CODE tags to keep your code formatted. See: BB Tags
    - How to attach Screenshots
    - Try searching for your answer first, see how
    - Test and validate results for all code on a copy of your worksheet!! How do you use the code you just found?
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com