I have data plotted in a chart. I have the Verticle axis options set to Auto
for the minimum value so that excel will figure it for me. Reason for this is
that I commonly hide or unhide data that in turn readjusts the plotted values
on the chart. Problem I am having and hope for a solution is that it almost
always defaults to 0. It will default to 0 even when a have values from say
600 to 1000. And even when it does auto adjust, it still will show 900 to
1200 for values that only range from 1020 to 1140. How can I maximize the
viewing so that data showing is as far top and bottom of the chart as
possible?
--
Thank you!