[AccessD] OT: Excel Question

I managed to answer my own question. There is a very inobvious menu to  
do this and tell it not to resize or move with data changes. Sadly it  
is the sort of thing that can be demonstrated, but really hard to  
describe, so I am not sure I can contribute the solution to the  
archives.

Debbie

Sent from my iPhone

On Sep 23, 2011, at 1:39 PM, Debbie <delam at zyterra.com> wrote:

> I have a database pushing data out to an Excel 2007 template. From  
> this data I am creating a variety of graphs that are stored in the  
> template.
>
> Everything works fine except the relative scales on 2 of the graphs.  
> They are side by side and the customer is adamant that the top and  
> bottom line up. This seems really easy, but it is not. One graph has  
> a dynamic y axis because the values can vary a lot. When they do  
> vary, the whole chart area will change height just a bit.
>
> Is there a way to fix the total chart height, while still allowing  
> the y axis to automatically determine the best tick marks and  
> scaling within that area?
>
> Debbie
>
> Sent from my iPhone
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com