4 Replies Latest reply: Mar 11, 2013 8:25 AM by katieoliver RSS

    How can I show multiple bar charts as a single stacked chart?

      Hi there,

       

      I have some data that I'm trying to display in a single bar chart instead of several separate ones.  Really hoping someone can help

       

      Data

       

      My data looks like this:

       

      CountryInternetTextEmailVideo
      UK1115
      USA2224
      India3311
      UK2312
      UK6433

       

      The numbers in the columns Internet, Text, Email and Video represent the frequency that people use these media types. 

       

      • 1 = every day
      • 2 = every week
      • 3 = every month
      • 4 = every year
      • 5 = rarely
      • 6 = never

       

      I would like to display the results of this table in a stacked chart as follows:

       

      chart3.jpg

      Would also like to create a list box that allows me to filter by country.

       

      Any help to acheive this would be much appreciated!

       

      Many thanks,

       

      Katie