18 Replies Latest reply: Sep 19, 2012 5:49 AM by whiteline _ RSS

    3d bar graphs

      Hey guys

       

      is it possible to create 3d bar graphs like the one in the atached file?

      I have tried but failed to find a way.

      appriciate any help

        • Re: 3d bar graphs
          Rajni Batra

          yes this is one of the chart style provided in bar graph under style Tab

          Did u try that?

          • Re: 3d bar graphs
            mayilvahanan ramasamy

            Hi

             

                 In bar chart -> properties->  style-> Look fifth or sixth option help you to achieve this..

            • Re: 3d bar graphs

              I have tried the properties in the bar chart option but it doesnt allow me to do that.

              This is how I have arranged my data in the table.

              All I can do is present as shown in the attachment.

              Really I want to present a format shown in my original post

               

               

               

              PersonsNoA1A2A3
              Person112%40%79%
              Person214%21%77%
              Person312%29%75%
              Person413%28%72%
              Person58%19%65%
              Person68%11%64%
              Person78%20%61%
              Person812%14%60%
              Person911%15%49%
              Person106%8%43%
              Person116%8%36%
              Person124%5%35%
              Person137%7%32%
              Person145%4%30%
              Person155%3%28%

              barChart_1.bmp

              • Re: 3d bar graphs

                When I convert it so An become the dimension then I have no expression to calculate/display.

                I simply transformed my table as follows.

                Still no joy. What would be the proper way?

                 

                 

                AnPerson1Person2Person3Person4Person5
                A112%14%12%13%8%
                A240%21%29%28%19%
                A379%77%75%72%65%
                • Re: 3d bar graphs
                  Aaron Couron

                  Yeah, thats a little strange.  Is either the name or the direction set up as an expression?  Because you will only get the proper rendering with two dimensions and one expression.

                    • Re: 3d bar graphs

                      this is my table that I am using to produce the above chart.

                       

                      NorthSouthEastWest
                      Tom13235414
                      Dick10118554
                      Harry1541556
                      Peter12144547
                        • Re: 3d bar graphs
                          Aaron Couron

                          OK, so you need to crosstable that data so that your table looks more like below.  Your values should be in a single column so that way you only need one expression to report on them.  I have attached the qvw as example.  Hopefully that makes sense.

                          Name Region Value
                          Dick East 85
                          Dick North 10
                          Dick South 11
                          Dick West 54
                          Harry East 55
                          Harry North 15
                          Harry South 41
                          Harry West 6
                          Peter East 45
                          Peter North 12
                          Peter South 14
                          Peter West 47
                          Tom East 54
                          Tom North 13
                          Tom South 23
                          Tom West 14
                          • Re: 3d bar graphs
                            mayilvahanan ramasamy

                            Hi

                             

                            Try like this,

                             

                            Dimension: Name and ValueList('North','South','West','East')

                            Exp:

                            If(ValueList('North','South','West','East')='North',Sum(North),if(ValueList('North','South','West','East')='South',Sum(South),

                            if(ValueList('North','South','West','East')='West',Sum(West),Sum(East))))

                             

                            Hope it helps

                        • Re: 3d bar graphs

                          thanks alot guys.

                          you've given 2 solutions here.

                          One is to transform the data as shown in Aaron's post.

                          Second option is to use Mayil's Valuelist with the if expressions above.

                          I think the better way for me to go about this is to use Mayil's method because then  wouldn't have to transform the data.

                          thanks guys.

                            • Re: 3d bar graphs
                              whiteline _

                              In some cases it's useful to have both representations of data.

                              Just add East, North, South, West fields to Aaron's table with corresponding values (skipping other region rows with nulls).

                              In this case you'll have a choice of what approach to use in a particular Chart or Expression.