Set Y-Axis max value to cell value without VBA?

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

You need VBA, but it's not terribly hard. Here's how (my site):

http://peltiertech.com/Excel/Charts...inkToSheet.html

and here's a utility that handles the heavy lifting for you (Tushar Mehta's
site):

http://tushar-mehta.com/excel/softw...hart/index.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"KR" <nospam@nospam.com> wrote in message
news:eNIKiNeVGHA.4608@tk2msftngp13.phx.gbl...
> 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
>
>