1 Reply Latest reply: Dec 15, 2016 4:38 AM by Matus Kelemen RSS

    creating excel line chart from QV model Table object

    Lorna Louw

      hi guys

       

      I need to create this in an Excel template...

       

      Capture.PNG

       

      Here is a mock-up of some data that would be in this chart...

       

      Please can you assist getting the look right?

       

      thanks!

        • Re: creating excel line chart from QV model Table object
          Matus Kelemen

          Hi,

          probably the easiest way would be to change the QV table to have expression per each Callcentre.

          Your export will then llok like this

          MonthYearAcquisitionsVaultCash…SupersizeHuntersWiners…
          <MonthYear_1><Acquisitions><Vault><Cash…><Supersize><Hunters>

          <Winers…>

          That way you can create the chart you want.

          It's still a bit tricky - you need to create the chart using the Header and one line of real data. After you have created the chart just replace the data lines with placeholders from nprinting.

           

          BR,

           

            Matus