[AccessD] OT: Excel Question

I do that myself all the time. Trouble is I couldn't find how to do it  
in Excel. Until I found that, there was no macro to record and no code  
to crib.

Debbie

Sent from my iPhone

On Sep 23, 2011, at 3:37 PM, "Rocky Smolin" <rockysmolin at bchacc.com>  
wrote:

> 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
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>