Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming a chart object
Sorry for a ramble but
I have an access database that holds information on the location of boats (Boat Names & Owners) and the XY co-ordinates of the spaces they are stored in. What I am trying to achieve is to see a map on the Access form of the area with the spaces and boat owners marked on it. Currently I am using Excel to link to the database, creating a scatter chart, using Bob Bovey's chart labeller to label the chart, then outputting the chart as a GIF file which I display as an image on the Access form. It all works perfectly and automatically, but what I want to do is eliminate using Excel. Have got closeish to doing it on occasions, but it is very flaky and not really working. daft asking how to eliminate Excel on an Excel newsgroup - but what the hell. My first problem is I have set the Rowsource of the chart to the correct SQL String, but apart from containing the XY data and the labels, I also hold the position of tha labels relative to the plotted points and also the orientation. Sometimes if I view the Chart datasheet, the data is missing and sometimes it is there. So could anybody tell me gow to force that datasheet to get the SQL information Thanks Phil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart with VB programming? | Charts and Charting in Excel | |||
Need help with Range object in Macro programming | Excel Programming | |||
Cannot Activate Chart Area in Chart. Chart Object Failed | Excel Programming | |||
Programming code to new object | Excel Programming | |||
Pie chart programming | Excel Programming |