Eliminating padded spaces in charts

  • Thread starter Thread starter routeram
  • Start date Start date
R

routeram

Hi,

When Excel plots a graph, it automatically extends both the axes t
some value greater than the maximum plotted value and lesser than th
minimum plotted value. This results in empty spaces on the sides of th
plot.

I was wondering if there is any way to eliminate these spaces, so tha
the whole plotted area is covered. I know you can alter the max and mi
values of the axes but is there any dynamic way of doing this? i.e if
change the data, I want the axes to adjust the maximum to the maximu
plotted value.

I hope I made myself clear.

Thanks
 
Back
Top