Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Creating an Excel Bar Chart/Line Chart in a Access Report
- Thread starter kswiss311
- Start date
MichaelRed
Programmer
start at the end, finish at the beginning?
Ms. A, Excel et al use hte MS applet ("Shart) to generate the graphs / charts. The only difference is the 'user' interface. In Excel, most of the properties / attributes are exposed directly, while Ms. A. makes the tasks a bit less intuitive, making the designed create the chart / graph in a control and then changing the properties / attributes via the design mode / edit or to set them programatically.
You can generally set up a work book with the data on one sheet and the chart / graph on a seperate one, then export the data from Ms. A. to the workbook / sheet (make sure to use a named range for the data) and have the chart auto update.
The reverse should also be pratical, setting up a LINK to the work book / sheet in Ms. A. and ysing the virtual table to generate the chart / graph in Ms. A.
In either of the above scenarios, both the db and the work book / sheet must remain in the environment, thus precluding the concept of developing the prersentation and moving the end point app to a different system or disconnecting from the network a-la-road work presentations.
MichaelRed
Ms. A, Excel et al use hte MS applet ("Shart) to generate the graphs / charts. The only difference is the 'user' interface. In Excel, most of the properties / attributes are exposed directly, while Ms. A. makes the tasks a bit less intuitive, making the designed create the chart / graph in a control and then changing the properties / attributes via the design mode / edit or to set them programatically.
You can generally set up a work book with the data on one sheet and the chart / graph on a seperate one, then export the data from Ms. A. to the workbook / sheet (make sure to use a named range for the data) and have the chart auto update.
The reverse should also be pratical, setting up a LINK to the work book / sheet in Ms. A. and ysing the virtual table to generate the chart / graph in Ms. A.
In either of the above scenarios, both the db and the work book / sheet must remain in the environment, thus precluding the concept of developing the prersentation and moving the end point app to a different system or disconnecting from the network a-la-road work presentations.
MichaelRed
- Status
Similar threads
- Locked
- Question
- Locked
- Question
