Embedding Excel chart in Access report

I'm running Office 2007 under Windows xp.

I have an unbound Excel chart in the detail section of an Access report. I use code to push specific fields to certain positions in the related spreadsheet. At the end of the code, I switch to the chart. When I view or print the chart, the datasheet displays. The datasheet changes from detail record to the next, as it should. I've tried other tips (Refresh and Clip), to no avail. I've placed a breakpoint on the End Sub statement and confirm that the chart is the current sheet.

Here's the essence of my code:

Dim objExcel As Excel.Application, objExcelWorkbook As Excel.Workbook
Set objExcel = Me.fraInquiries.Object.Application
Set objExcelWorkbook = objExcel.Workbooks(Me.fraInquiries.Object.Name)
With objExcelWorkbook.Sheets("datInquiries")
.Activate
.Range("B2") = intInquiryToDateGross
.and other cells.
End With
With objExcelWorkbook.Sheets("chInquiries")
.Activate
.Refresh
End With

What am I doing wrong? Why won't my chart display

Sponsored Links:

Related Topics

Why deform the embeded excel char in Access 2007 report
In fact, we have a application access who work well with access 2003, after update to access 2007, the application work, but the chart in excel is deformed.

in vba, I embed a excel workbook into access report, in access 2007, the chart in excel sheet deform. the line in the chart become more thick and the axis y title become unreadable. mais when I return to Excel design mode, the chart come bace to be normal, I dont uderstand what happend?
I embed the excel workboon like this, it work well in ACESS 2003
Set xlApp = Reports(strReport).OLE1.Object.Application
Set xlWrkbk = xlApp.Workbooks.Item


Report chart problem
I have been using access for a couple of months and I think I am starting to get the hang of it, well nearly. Anyhow my current problem is with regard to charts.

I have a report based on a query. I have set up a chart which totals up some costs and displays them in a bar chart against the year at which they are projected to occur. The chart works fine with one minor flaw.
When I preview the Report it produces a chart for every record giving me 50 odd pages. Is there a way I can produce a report with just one chart based on the fifty records? I used the chartwizard to produce the chart and I may have missed a trick along the way.


Chart on Report
I am looking to add a small pie chart to my report. I have 5 fields that i want to display. I can not get it to work. when i go thru the wizzard and when it displays its just a blank chart.im using access 2007, and i want this chart on a Report.


Charting in Access
What is the best way to add a column chart (MSGraph.Chart.8) to a report. I have tried adding it directly to the report, but have been told it is best to build it as a form, then somehow add that to the report. Is there a difference between the two?
The problem I am having is with the way the column chart displays. In design view, I formatted 4 of the data series as a stacked column chart, each set up with its own color, and a fifth data series as a line chart on the same axis.

When I change to print preview, the second data series (column) turns into the line chart, & vice versa. I tried cutting & pasting the columns how I want them in the little Excel spreadsheet thing that pops up with the chart in edit mode,(and just what is Expr1002 in the upper left corner?), but it keeps changing back.


Unbound object not showing all of image
I have an unbound object in the detail section of my report that is linked to a chart in Excel. When I open the report (in preview or design view), only the top left corner of the chart shows up.

I've tried resizing the chart in Excel, and resizing the unbound object frame, but it won't show the whole chart.


Charts in reports not showing
I have built a couple databases in Access 2003 that contain charts. I gather the data in a query (or two or three) and use a transfer spreadsheet macro to export the information to Excel, which puts the chart together.

When the report is opened in Access, the chart shows up as an OLE Unbound picture. This has always worked great since charting in Access is so limited.
Last week I converted to Access 2007. Since then, when I open these reports, either no chart shows up at all, or just the upper left corner is on the report. I have allowed all content into the trusted zone, and double checked all of the paths, changing the excel extentions to xlsx.

This is happening to all of my charts, even though they seem to be showing up ok in excel, they aren't showing up in Access.


Chart in Report
I have been using Access 2003 for a year or so, and now I would like to create a chart, but am clueless how to do this using the Wizard

I have conducted a survey - the results of which are presented in a spreadsheet (EXCEL)

I imported it into an Access data base table, but now would like to have a bar chart that shows how many men and women (2 bars) took the survey (This is a field in the table)


Large Chart / Graph Issue
I have a large bar chart in my report with so much information that not of my horizontal labels are printing. Is there a way to split the chart so that it prints in two sections like you can in Excel?


Graphing/Charting - Access vs. Excel
We are debating incorporating some excel charts and reports into an Access database that populates the table used by Excel as a datasource. I have managed to develop a graph on a form that resembles the Excel chart, but without all the bells and whistles.

So far I have found the Access chart wizard to be much less friendly than Excel. In addition I want to set the text in the title and axis legends based on values on the form.

I have not been able to find a name or list of properties for the chart I created so I'm not sure how to go about it.

"Is Access up to the task?". The motivation is to have the whole application in a single program. I'm not sure it is worth the trouble.


Is There A Way To Move An Excel Pivot Chart
I have a quick question. Is there anyway to move an "Excel Pivot Chart" (The actual chart) around using VBA in access. I'm trying to mount the chart on a certain position of my spreadsheet but with no luck. I can't find any code that will set the charts location. If anyone knows if this is possible or not


Embedding Dynamic Reports in Wordpress Blog
Can anybody help me embed a dynamic report? I looked at Report Snapshots, but they are static, I think, and then I would need to update the report every time I made a page. I want the webpage users to be able to view a report from the lending library template, so that they can see what is checked out. I am embedding this into a wordpress.com blog.


How to opena report in pivot chart view by default
I like to open a report as a pivot chart from my query.
How to open a report by making the default view of report as pivot chart?.
I am able to manually create a pivot chart by clicking pivot chart view from the sql view in a report. Then I pull in the required columns to the x axis and y axis and a graph is generated. I do not know how to save it and open the report by default in pivot chart view every time I click a button


Chart in report
could you please tell me how to get the information from why query into a chart in my report
I have opened my report in design view put the chart in using wizard from my query but I dont know how to put the real data to the chart . as it shows me the test sample

also it only allows me 6 fields is it possible to put 12 in


Bar Chart based on report calculations...
I am using Access 2002. I have a query with one field called txtUsedKnowledge that has four possible responses. They are Never, Small Extent, Moderate Extent and Great Extent.

I did many calculations with these including counting them individually and getting the percent for each one based on the over all count. Now I would like to create a bar chart with the four responses listed that will update each time it's run.

I created the chart but have to type in the figures for each response myself. Since the calculations are done on the report and not in the query is there a way to use the fields from the report. Unfortunately, this is my first time trying to use the Chart feature in Access. If I can't do this with the Chart option is there another way to have a bar appear on a report?


How to open a report in Pivot chart view by default
I like to open a report as a pivot chart from my query.
How to open a report by making the default view of report as pivot chart?.
I am able to manually create a pivot chart by clicking pivot chart view from the sql view in a report. Then I pull in the required columns to the x axis and y axis and a graph is generated. I do not know how to save it and open the report by default in pivot chart view every time I click a button .


import excel files into access automatically
I have to create a system that automatically imports Excel files from a folder in the hard drive into an Access table. I want to make it so all the users have to do is hit a button and everything happens automatically. I know its possible because I was able to create it using VBA in Excel but I cant make it work for Access.

I believe I have to use "currentproject.path" instead of "ThisWorkbook.Path" but Im not entirely sure. All the files are save in this format: Seating Chart Report- city name.xls The city name is different for every file. The subfolder all the files are saved in is called Attachments and the table they need to be imported into is called Seating Chart. The Excel files and Access database are both located in the same main folder called "Seating Chart Project."


charts in Reports
Access 2007, in design view of a report I added a chart, but it isn't able to cope with the amount of data so throws up a few errors then the chart is blank, so I managed to create a pivot chart and added the form to my report, this seems to work much better except in print preview, the pivot chart in the report shows boxes with drop filter fields here etc and horrible gray boxes for date and sums. can these pivot charts be altered to look better?


generate a chart report
I have a query like below and want generate a chart base on it, how can I create a chart in access like below chart?


generate a chart report
I have a query like below and want generate a chart base on it

how can I create a chart in access like below chart?


2 tables. 1 graph
I have 2 separate revenue tables (by date) and I want to chart both of them in one chart. But still separate within the chart. (e.g. bars with another bar on top)

I have a made a chart report for the first table. I want to add this new table to the chart but cant see how.

Chart wizard makes u choose a table first