Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Move chart in Excel from Access
I have code that creates a chart in Excel and moves that chart to a certain sheet. This code works in my home Access 2003 (and Excel 2003), but not from Access 2000 (and Excel 2000), which I need it to work from. It just creates and leaves it in the existing "Sheet1." I want it to be in the existing "ReportCharts." What could be wrong? The line in question is .ActiveChart.Location Whe=xlLocationAsObject, Name:="ReportCharts" The library references seem to be intact in both versions. This is the full section of code: With objExcel .Charts.Add .ActiveChart.SetSourceData Source:=.Sheets("Chart Data").Range("A" & intTitleRow & _ ":M" & intCurYearRow), _ PlotBy:=xlRows .ActiveChart.Location Whe=xlLocationAsObject, Name:="ReportCharts" With .ActiveChart .HasTitle = True .ChartTitle.Characters.Text = Years(i) .Axes(xlCategory, xlPrimary).HasTitle = True .Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "MONTH" .Axes(xlValue, xlPrimary).HasTitle = True .Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "COST" .HasDataTable = False End With End With -- justme0010 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it time to move to access? | Excel Discussion (Misc queries) | |||
excel chart with data source from an access query | Charts and Charting in Excel | |||
How to draw a line on a chart, and have it move with the chart? | Charts and Charting in Excel | |||
Exporting an Excel Chart into Access | Charts and Charting in Excel | |||
Move to Access? | Excel Worksheet Functions |