AnsweredAssumed Answered

Dynamic Upper Range for a Bar Chart?

Question asked by chill on Aug 25, 2015
Latest reply on Aug 28, 2015 by chill

I have need to dynamically set the upper limit for a number of bar charts on a single .pdi. It sounds like this would need to be a VBA thing and my VBA skills bucket is empty .... My scenario is as follows:

 

We get rejects for Machine 1 from several components

 

           Camerareject1

           Camerareject2

           Camerareject3

 

We then use a Dataset to get the reject percentage for the machine

 

(Camerareject1+Camerareject2+Camerareject3)/InspectedParts = OverallRejectPerc

 

What I have been asked to show in a Bar Chart is if the Reject % calculates to be 10%, then 10% should be the upper and for Camerareject1's bar, I should display what part of the 10% is belonging to Camera1, Camera2 and so on

 

Any ideas on what this looks like, would be greatly appreciated.

Chris

Outcomes