5 Replies Latest reply: Jul 6, 2012 5:17 AM by Siva Boggarapu RSS

    Straight table chart help?

    Siva Boggarapu

      Hi Everyone,

       

      I have one stright table like below.

       

       

      Product

      Col1

      Col2

      Col3

      Col4

      Total

      2,116,704.34

      4,576,615.28

      1,629,538.75

      3,295,270.88

      11,618,129.25

      Cloth

      1,502,067.14

      2,704,930.72

      588,569.74

      1,893,134.00

      6,688,701.60

      Home Needs

      138,331.52

      543,271.41

      235,496.46

      364,102.61

      1,281,202.00

      Computers

      46,606.41

      339,153.24

      65,876.64

      427,750.10

      879,386.39

      Electronics

      89,364.61

      395,642.71

      172,994.64

      70,056.00

      728,057.96

      General

      105,644.48

      96,849.44

      35,159.18

      329,187.00

      566,840.10

       

       

      I want to make this chart like below year wishe sales. How it is possible in stright table

       

      ProductCol1 Col2 Col3 Col4 Total
      Sales=2009Saes=2008  Sales=2009Sales=2008  Sales=2009Sales=2008  Sales=2009Sales=2008
      Cloth1,502,067.14

      1,502,067.14

      2,704,930.721,502,067.14588,569.74588,569.741,893,134.00588,569.746,688,701.60
      Home Needs138,331.52138,331.52543,271.41138,331.52235,496.46235,496.46364,102.61235,496.461,281,202.00
      Computers46,606.4146,606.41339,153.2446,606.4165,876.6465,876.64427,750.1065,876.64879,386.39
      Electronics89,364.6189,364.61395,642.7189,364.61172,994.64172,994.6470,056.00172,994.64728,057.96
      General105,644.48105,644.4896,849.44105,644.4835,159.1835,159.18329,187.0035,159.18566,840.10

       

      Best,

      Siva