PC Review


Reply
Thread Tools Rate Thread

chart printing automation

 
 
=?Utf-8?B?anVzdF9hc2tpbg==?=
Guest
Posts: n/a
 
      16th Jun 2005
Hi,
I am trying to fiqure out if there is way ( perhaps by script or macro)
that I can automate the process of selecting a form making a graph with
specific parameters, then printing it out. Then changing the parameters &
priniting that one out so that each action does not have to be performed
manually.

consider the following example :

|
|
Quantity |_____________________

months

In my data, I have Apples, Pears, Oranges. The chart showing the
quantity of each fruit for each month.

I want a script or macro to select the parameters print a seperate chart for
each item of fruit.

Is there something like this available?




 
Reply With Quote
 
 
 
 
Duane Hookom
Guest
Posts: n/a
 
      17th Jun 2005
Are you aware that you can place a chart in the detail section of a report
based on a record source of one record of each fruit? Set the link
master/child properties to the fruit field to create three graphs, one of
Apples, one of Pears, and one of Oranges.

--
Duane Hookom
MS Access MVP


"just_askin" <(E-Mail Removed)> wrote in message
news:84DF81A5-ACDB-44CD-BF84-(E-Mail Removed)...
> Hi,
> I am trying to fiqure out if there is way ( perhaps by script or macro)
> that I can automate the process of selecting a form making a graph with
> specific parameters, then printing it out. Then changing the parameters &
> priniting that one out so that each action does not have to be performed
> manually.
>
> consider the following example :
>
> |
> |
> Quantity |_____________________
>
> months
>
> In my data, I have Apples, Pears, Oranges. The chart showing the
> quantity of each fruit for each month.
>
> I want a script or macro to select the parameters print a seperate chart
> for
> each item of fruit.
>
> Is there something like this available?
>
>
>
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart Automation jane Microsoft Excel Discussion 1 20th Jan 2007 05:04 AM
Chart automation =?Utf-8?B?Q2hhcmxlcyBX?= Microsoft Excel Charting 1 24th Aug 2006 09:48 PM
Chart Automation SteveG Microsoft Excel Charting 2 2nd Dec 2005 07:48 PM
Chart printing automation - help! =?Utf-8?B?anVzdF9hc2tpbg==?= Microsoft Access VBA Modules 0 16th Jun 2005 08:15 PM
vc++ automation: opening chart as chart window and setting scale Mike Biolsi Microsoft Excel Programming 0 7th Feb 2004 08:13 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:38 PM.