Dynamic Histogram chart

[BaGRoS]

Hi

I use in name manager, name Scatter as:

=OFFSET(HiddenTemp!$D$2,0,0,COUNTA(HiddenTemp!$D:$D)-1,1)

For data X Y Scatter, as:

=HiddenTemp!Scatter

and looks like working good.

I try use same for Histogram chart, and not working only the first time, when I write:

=HiddenTemp!Scatter

later only remember same range, not working as dynamic table.

Any help please?
Kind regards,
BaGRoS

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Dynamic Histogram chart
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.