I have a query which pulls out the following data from a crosstab query, where the target week is on
the timeline axis, and the Target is what is supposed to be complete by then.

I have another query which pulls out the actuals, so the intent is to plot the target line, which is
in effect a non linear glidepath, and then overlay the actual completions so we can measure
adherence to plan.

It is (fairly) straightforward to plot bar charts and line graphs throuh each point by week,
however, what I need to do is have te all up total at the start, and then decrease to 0 as the
activities are supposed to complete, with another data series showing actuals doing the same, and
the start point will obviously be the same for both.

CAn anyone point me to a resource, or give me some ideas on how to create the glidepath from
personal experience. There are 9 different sections with a section code for each, so my intention
was to use the same underlying query, and filter for each section to print out the graphs, using
globals to title the graph (as part of a report) for each one.

I realise that graphing is not Access's strong point but it would save me exporting to Excel and
having to have refresh of data every time a print was required

Thanks... J


TargetWeek Target
802 97
806 14
915 16
917 10
1050 30
1111 97
1129 1
1132 3
1143 11
1151 1



--
--------------------------------- --- -- -
Posted with NewsLeecher v4.0 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

On Jul 11, 4:25*pm, schwallyhoo <sum... (AT) hotmail (DOT) com> wrote:
Can you post a link to an example of your Excel graph? Is your Excel
graph adequate for your requirements? Is it like a Burndown graph in
Agile? The fact that Excel can graph it makes it likely that Access
can graph it also. Access can also automate the entire export of data
and creation of graphs in Excel, including automatically changing bars
to have a 3D look. I just did that recently in Access 2007, so I
should be able to supply a code sample if that is the direction you
choose. Personally, I have Access create most of my graphs directly
into PDF format using data from queries because that way I am not
limited to the chart choices presented by Excel.

James A. Fortune
CDMAPoster (AT) FortuneJames (DOT) com