Straight horisontal line trough single-line graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger Oshaug - 28 Mar 2006 00:13 GMT

Access 2003

I have a simple line graph with one line and I need an extra horizontal
line in that graph. I want something similar to this, (without the
vertical line):

http://www.peltiertech.com/Excel/Charts/ComboCharts.html#AddLine

except the value for the "height" of the horizontal line will change for
each record.

Information on how to manipulate graphs like this in Access 2003 seems
sparse and I can`t figure out how to do it. Any ideas out there?

Any help is appreciated.

Reply to this Message

Roger Oshaug - 31 Mar 2006 00:42 GMT

I did the "Export needed data to Excel and create and run macro from
Access VBA" posted by Red(thank you). This works fine. Now I just need
to get the graph back into Access so that we can watch the graph change
while we go from record to record in a form. I have tried:

ActiveChart.Export CurDir & "\filename.gif", FilterName:="GIF"

indeed the file is created and looks ok, but I am not able to make it
show in my Access form. I have tried with the Unbound Object Frame
linking but all I get is a white background with the filename on it. I
am allowed to "Activate content" by right-clicking in design view and
get to view the picture from a image-viewing application but can do
nothing with it when in form view. When I add the file as a Image it
shows up just fine. Has anybody experienced the same problem, or is it
just that I am missing something here.

Any help is appreciated.

> Access 2003
>
[quoted text clipped - 11 lines]
>
> Any help is appreciated.

Reply to this Message