H
Holt88
In XL97, I'm working with dynamic pie charts. I have drop
down macros that change the data behind the charts, thus
manipulating the charts themselves. However, with each
change of the source data, the chart gets smaller and
smaller(shrinking). Non-pie charts are also affected, in
that the legend will gradually make its' way up to the top
of the page with each refresh of the source data. Any
explanation for this would be quite helpful. Thanks in
advance-
down macros that change the data behind the charts, thus
manipulating the charts themselves. However, with each
change of the source data, the chart gets smaller and
smaller(shrinking). Non-pie charts are also affected, in
that the legend will gradually make its' way up to the top
of the page with each refresh of the source data. Any
explanation for this would be quite helpful. Thanks in
advance-