topic Re: NPrinting Excel Chart Y axis minimum and maximum values cannot be set in Qlik NPrinting

NPrinting Excel Chart Y axis minimum and maximum values cannot be set

Dee1 — Sat, 23 May 2020 05:57:07 GMT

Hi all

Can you please please let me know if I can set the NPrinting Excel Chart Y axis to show as 0% for minimum and 100% as maximum values. It keeps on showing up as 120% max or 80% minimum.

Also can the values be sorted as max to min and not by alphabetical order.

Many thanks

Re: NPrinting Excel Chart Y axis minimum and maximum values cannot be set

Lech_Miszkiewicz — Mon, 25 May 2020 03:14:49 GMT

1. yes you can - this is really Excel setting (not even NPrinting setting). I tested it and and I was able to set it up to whatever value I wanted by:

right-clicking on the chart in excel editor
selecting "format axis"
axis options --> bounds--> and manually setting minimum and maximum values

2. regarding sorting - NPrinting will inherit sorting used in QlikView object used as data source. Make sure you setup sorting in QlikView first.

Re: NPrinting Excel Chart Y axis minimum and maximum values cannot be set

Dee1 — Mon, 25 May 2020 04:09:49 GMT

Thanks for your reply Lech.

Yes I tried that many times. It is very strange. I also set to max value of 100% but it keeps on producing the max of 120% which I cannot have as 100% is the max. Could it be tied to the way the source data was set up?

Best regards Dee

Re: NPrinting Excel Chart Y axis minimum and maximum values cannot be set

Lech_Miszkiewicz — Mon, 25 May 2020 05:31:32 GMT

I don't know,

Without looking at your template setup and properties setup used in your NPrinting designer it is just a guessing...

I don't believe it is source - as source has nothing to do how you configure your chart properties in excel template in NPrinting designer.

So I am assuming you are setting up max as 1 (as 1 is 100%) on Y axis properties, right?
Are you using keep source format?

Can you share screenshot of your template (especially bit where you setup min and max - you may need to take few screenshots with all the steps you are doing) and maybe output of your report so we could see how this data is being published in excel and what format it is in (you can dummy up data and remove all branding or sensitive data as long as you don't change skeleton of report and number formatting.

Re: NPrinting Excel Chart Y axis minimum and maximum values cannot be set

Dee1 — Mon, 25 May 2020 05:49:00 GMT

Hi Lech

Thanks for your reply.

Below are my screenshots as requested. Source data are straight forward data in %. I have tried a zillion ways to fix the end results (last two screenshots as examples). Many thanks for your kind assistance.

Best regards

Dee

Re: NPrinting Excel Chart Y axis minimum and maximum values cannot be set

Lech_Miszkiewicz — Mon, 25 May 2020 06:56:45 GMT

First thing i notice on your screenshots is that next to your 0.0 and 1.0 you have an "Auto" selection.

When I edit my axis bounds, after putting values I get to see: "Reset", but on your screenshot you still have "Auto" options which i am assuming is causing chart to ignore values you entered

Re: NPrinting Excel Chart Y axis minimum and maximum values cannot be set

Dee1 — Mon, 25 May 2020 09:47:25 GMT

Hi Lech

Thanks so much, I really appreciate your assistance - Reset is the key!!!

Best regards

Dee

Re: NPrinting Excel Chart Y axis minimum and maximum values cannot be set

Lech_Miszkiewicz — Mon, 25 May 2020 09:50:21 GMT

Does it mean it works for you now?

cheers

Lech

Re: NPrinting Excel Chart Y axis minimum and maximum values cannot be set

Dee1 — Mon, 25 May 2020 09:58:10 GMT

Yes, finally!!! It had been puzzling me for days on end.

And I am ever so thankful.

Best regards

Dee