Bar chart doesn't work

[Ethel]

Hello, I'm trying to create a bar chart in NPrinting using table data

My data looks like this

PeriodYear	1	Name
<PeriodYear>	<if('$(=minstring(PercentCount))'= 'Count',num(avg({ $(vPeriodType), PeriodYear= {"=$(=vPriorFiveYear)=$(=vPeriodYear)"},TimeFrame = {'Current Year'}}aggr(sum({$(vPeriodType), PeriodYear= {"=$(=vPriorFiveYear)=$(=vPeriodYear)"},TimeFrame = {'Current Year'}}[# HeadCount]),[%PeriodSKey], Gender)),'###,##0'),num(sum({ $(vPeriodType), PeriodYear={"=$(=vPriorFiveYear)=$(=vPeriodYear)"}, TimeFrame = {'Current Year'}[# HeadCount])/sum(total PeriodYear{$(vPeriodType), PeriodYear={"=$(=vPriorFiveYear)=$(=vPeriodYear)"}, TimeFrame = {'Current Year'}[# HeadCount]),'#,##0.0%'))>	<=Gender>

My bar chart looks like this

(Columns for each year are apart, not together). I tried to play with powerpoint setting, nothing helps. I think that Npriting treat my data this strange way. Is there anything that can be done? I also tried to use stack chart instead of bar chart, but NPrinting replaces stack chart with bar chart. Thanks a lot in advance! 

That's how it should look like

Thanks a lot in advance!

[Lech_Miszkiewicz]

Hi

1. Are you using PowerPoint Template?
2. Screenshot is not from PowerPoint template so where is it from?
3. Below are the steps I made in Power Point and it works as designed

Now the steps

1. add some dummy data to the template so series becomes visible
2. edit series as per your requirements
3. use GAP Width and Series Overlap to get required results
4. Once you happy remove previously added records from template

[Ruggero_Piccoli]

Hi,

You have to define the data series in the PowerPoint template

Select the correct type of native PowerPoint chart, for example, cluster bar chart, and run a preview:

Refer to https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/PowerPointReports/Chart-Native-Table...

Best Regards,

Ruggero

[Ethel]

Hello, thank you very much for your help.

I'm using power point template. I clicked insert chart->edit data, and changed data in excel to my data. Maybe I should do something else?

If add dummy data 

that's my result, columns are not near each other.

Thank you very much again!

[Ruggero_Piccoli]

Hi,

Could be a problem of the selected type of chart? Try to generate a preview with data from Qlik NPrinting and open that data source of the chart from the generated file. Check that all needed rows are included and that the type of chart is correct. You can also try to edit the chart there with your real data to understand what could be the issue.

Best Regards,

Ruggero

[Ethel]

Thank you! Data from Nprinting is working fine, but my data gives weird results  unfortunately:( I need bar chart and in Qlik sense bar chart worked fine. I converted existed bar chart to the table and imported that table in NPrinting. v Any other ideas what I can do to make it work?

Thank you very much for your help!!!

[Ethel]

I think the difference in your example and mine is that I have only one measure (totals) and two dimensions (gender and year). Is it possible to create this type of chart? Or should I have only one dimension? 

Thanks a lot in advance!

[Lech_Miszkiewicz · Accepted solution]

I was never able to pivot data in nprinting ppt chart so the solution for what your requirement is would be to use set analysis for "Male" and "Female" measures.