Use vLookup Count field in a Chart › Forums › vLooup for SharePoint › Use vLookup Count field in a Chart This topic contains 2 replies, has 2 voices, and was last updated by Alexander Bautz 4 years, 4 months ago. Author Posts April 17, 2015 at 17:03 #7432 Gerard GrahamParticipant Hi there I’ve looking to create a chart based on a count of values generated by the vLookup. As the count is done on the fly and not stored it is not possible to generate a chart. Is there a clever way of doing this? Thanks Gerry April 21, 2015 at 11:28 #7440 Gerard GrahamParticipant Hi there How about a static value field for a vLookup column when count/sum/average is used. Static field could be similarly named as the look up version or selected in the configuration form. Regards Gerry April 22, 2015 at 19:54 #7447 Alexander BautzKeymaster Hi, Sorry, but vLookups does not “exist” in the parent list. The query is performed on the fly and there are no values stored. Your best bet is to create a chart directly targeting the child list. Alexander Author Posts You must be logged in to reply to this topic.