Charts on a worksheet. Keeping the plot area size constant

Hi,

Can you be a little more specific as to what you are trying to do?

While a chart is an object within a worksheet the plot area should not alter I don't think. Switching it between a worksheet object and a chart sheet may alter things but are you just doing this once or repeating the process for some reason?

Dom

Dom,

Thanks for your response. I had originally thought the plot area was changing due to varying the data the chart was displaying. What I eventually realized was the change in the plot area size didn't occur until I did a print preview or an actual print of the worksheet. I'm a little confused by it all, but I'm using the camera from the tool bar to take a picture of the chart and toggling the picture of the chart on and off on another sheet by pressing a button (when the chart changes, the picture automatically changes) (I wanted to have a layered effect and use less space). For some reason if I have the picture generated by the camera tool bar button as a part of my workbook, the chart the picture came from is altered (plot area size expands to its max size), but if I cut the picture created by the camera tool the original chart will not be altered when I print or use print preview. Can't say that I understand why, but atleast I have an understanding of what is occurring.

Thanks