View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
ruddojo ruddojo is offline
external usenet poster
 
Posts: 7
Default Define Autoscale parameters in Chart

Current autoscale in graphs uses too wide of a scale range making the lines
in a line graph look flat. Want to view more of a close up on the range that
is graphed. For example: the autoscale may set the scale at 0 - 100 when
only the numbers from 20 to 40 are used. Can the autoscale be set to graph
only the range with numbers --- like a close up to see the change more
distinctly. I have data automatically populating graph tables and don't want
to manually go in and set up each one each time there is new data. Any help
would be appreciated, it is very tedious to change a presentation with 44
graphs.