[AccessD] OT: Excel Question

Are you asking to fix it from the VBA in the Access mdb? If so, I've been
able to automate everything in Excel from Access by recording a macro in
Excel to do what I want and then cribbing the Excel code into the Access
module.

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Debbie
Sent: Friday, September 23, 2011 11:39 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] OT: Excel Question

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