PPT table trendline in NPrinting

[SHurleySteward]

Making a chart in powerpoint because they want to have the data and chart all matching up like this:

I can get the data to pull in correctly,  and most everything in the chart, but I cannot create a trendline (dotted blue). 

There's no data when I'm working in the template, so the trendline option won't activate to select.  I've tried copying in the chart once it's rendered with an added trendline, but if I try to regenerate the report, I get weird errors.

I tried adding some hard-coded data long enough to create a trendline, but Trendline was still greyed out.

I suspect the answer is:  can't do that.  But I figured I'd throw out the question, in case I overlooked something obvious (or even something tricky).

Thanks!

[Lech_Miszkiewicz · Accepted solution]

Hi,

Once you go over my testing below you may have a good or bad news. 

In short if your goal is to add trendline to your line on chart it is all easy and possible. 

I started my testing from PowerPoint (not NPrinting Power Point but simple PowerPoint File). I created empty slide and clicked add chart. I used stacked bar chart and then changed one of the series to line. So when I do this trendline is not available. My understanding is that Power Point does not know how to support such configurations by default so you need to help it little bit.

From the chart we see that 2 series are having stacked mode and line is just regular line. If I click on one of the segments of the stack I am still unable to add trendline as I guess it cannot do this for stacks and it seems to be powerpoint limitation... However I am able to right-click on the line on the chart and click "Trendline" (first screenshot below already in NPrinting) and that opens the menu where I can choose options for it (next screenshot below). 

after runnig preview trendline appeared cirrectly on the chart without issues ( see highlighted below)

To simplify work flow I do all setup with few rows of data populated in the chart and once I am happy with look and feel I remove records which I dont need (see below .gif)

Summary:

• you need to choose series from the chart to which you want to apply trendline and that series cannot be a stacked one and you good to go. That is a good news as I think this will solve your issue.
• workaround for series which is stacked would be to create trend series directly in Qlik table and bring it in to the chart just as normal data. Drawback will be that such solution will bring 4th series to your chart and will be visible in the table bellow as 4th row of data.

Hope this helps.

cheers

Lech 

[SHurleySteward]

Excellent.  Thank you for the detailed steps.  I was in the right ballpark, but failed to set up the temporary data correctly.  I have it working now (my customers will be pleased!).