Nprinting excel native graph are always printing only based on first value in Level

[guruprem]

Description:

I am trying to create a excel native graph in Nprinting

Scenario-1 : Without applying any level Designer screen:

Scenario-1 : Without applying any level Excel output screen:

there is no problem with Scenario-1

Scenario-2 : After applying level in Designer screen:

Scenario-2 : Output

Here two graphs are generated but both graphs are referring only First Value in Level i.e. Automotive and Graph for the Value “B*********” was never generated .

Attached is the excel output 

[Frank_S]

Hi @guruprem 

I tried to get this to work but since it is not possible to place 'levels' tags around an MS chart, this won't work. The MS chart doesn't take up specific cell values ie; A1 B1 C1 etc (it can be dragged like an image anywhere on the sheet and partially cover some cells only) so it can't be used in the manner you suggested.

However when enabling the 'year' dimension using the NP page feature, I did get a separate chart for each year value.

See attached.

Hope this helps...

[guruprem]

Hi @Frank_S  ,

Thank you very much for the clear explanation and workaround.