I have a sheet with 4 charts on it. All the same size. I am trying to make it so that when you click on a button associated with a chart it will make it larger for a more detailed view. I am not trying to make it maximize, I want it to change to a specific size. I have come to the conclusion that I will need to use a macro to do this. any guidance or other ideas are appreciated.