I'm working on a home-grown pareto chart in my workbook; the data will
change and I'd like to dynamically have the (primary) Y-Axis max match the
sum of all values so that that it will synch with the secondary Y-axis which
will always have my 0-100% of the total (line). Is there an easy way to
force the primary Y-axis to have a maximum value matching a cell in my
worksheet?
Thanks,
Keith