Topics Search

Embedding Excel chart in Access report

Embedding Excel chart in Access report
Views: 49
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:

More topics

 

Why deform the embeded excel char in Access 2007 report

Preview
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
 

Chart on Report

Preview
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.
 

Report chart problem

Preview
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.
 

Charting in Access

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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