10 Replies Latest reply: Apr 11, 2014 2:27 AM by Jelly CHEN RSS

    Area Chart(or line chart) in chart table

    Jelly CHEN

      Hi All

       

      Now I have a serious steps in Excel:

      1. Original Table

      YearProductGrade
      20111A
      20112A
      20113B
      20114B
      20115B
      20116C
      20117C
      20118C
      20119C
      201010A
      201011B
      201012B
      201013C
      201014C
      201015C
      200916A
      200917A
      200918A
      200919A
      200920B
      200921C

      2.

      201120102009
      A214
      B321
      C431
      Total966

      3.

      201120102009
      A22%17%67%
      B33%33%17%
      C44%50%17%
      Total100%100%100%

       

      4.And Then I could insert a line chart:

      111.jpg

       

      And My question is How can I just load the original data from my data source and insert the final area chart directly?