06-12-2018 08:18 AM
I seem to be having problems finding any documentation showing how to create a stacked bar chart, Pareto sorted by the total of the stacked bars. It's easy to create a stacked bar chart, but trying to sort that by total seems to be a problem. My thought is to create a separate chart from a different table with just the totals and somehow link the X axis (category) and then hide the totals - ie adjust transparency. But, I am not finding any documentation on tying/linking/synchronizing the axis. I tried creating a custom graph in VA where you merge axis, but then that expects both graphs to be from the same data set. Any suggestions?