5 Replies Latest reply: Sep 9, 2016 2:57 AM by André Kabalkin RSS

    From Pivottable to diagram - formel problem

    André Kabalkin

      Dear experts,

       

      I think that I have simple problem: I have a pivottable. Each column contains a formel.

      I have data from Jan - to Mai. Another columns are forecast-values (yellow).

      Now I want to show this values in diagram. Existing values from Jan to Mai are displayed. Column from Jun to Dec are not displayed like in the pivottable

      In the axis I show the month with interval ( Max: 12).

      How I can display the formel for each Month in the diagram ?

      graph.JPG