problem with line chart on macro

  • Thread starter Thread starter Tla
  • Start date Start date
T

Tla

4 line charts are created using 3 columns for each graph as the data source.
while recording- these graphs come out fine, but when i replayed it- it did
not work. the debugger pointed this out:
ActiveChart.SetSourceData Source:=Range( _
"Sheet3!$A:$A,Sheet3!$E:$E,Sheet3!$E:$E,Sheet3!$Z:$Z")
help!
 
Tla,

The focus of this newsgroup is macros in Access, the database program, and
these are very different from Excel macros. You will have a better chance
of getting good help in an Excel newsgroup.

--
Steve Schapel, Microsoft Access MVP


Tla said:
4 line charts are created using 3 columns for each graph as the data
source.
while recording- these graphs come out fine, but when i replayed it- it
did
not work. the debugger pointed this out:
ActiveChart.SetSourceData Source:=Range( _
"Sheet3!$A:$A,Sheet3!$E:$E,Sheet3!$E:$E,Sheet3!$Z:$Z")
help!
Click to expand...



__________ Information from ESET Smart Security, version of virus signature database 4193 (20090626) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top