I'm using Access-to-Excel automation to build a Pareto Stacked Bar Chart w/
31 variables.

I would like to have ALL 31 variables in the Data Table at the foot of the
Chart. NOT really concerned with how the Stacked Bar Chart looks, but rather
looking at the Counts in the Data Table.

I had automated 17 of the 31 variables, and noticed apparently a Data Table
nicely displays 10 to 12 "Series", but truncates as more Series are added.

Is there a way I can display ALL 31 varaiables in the Data table??

Would also like to utilize a Legend at the Top of the Chart. I am able to
change the size of the Legend and might be able to assign "Totals" for the 31
variables in the Chart's Legend.

Thoughts? TIA - Bob