Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using names
Thanks for your answers, and I guess local function names are not s cool then. I tried ActiveWorkbook.Names.Add Name:="myX", RefersToR1C1:= _ "=OFFSET(sheet1!R10C7,0,0,1,sheet2!R7C2)" and for the Values ActiveWorkbook.Names.Add Name:="myY", RefersToR1C1:= _ "=OFFSET(sheet1!R93C7,0,0,1,sheet2!R7C2)" , with Set Currentchart = ChtObj.Chart Currentchart.ChartType = xlXYScatterLines Currentchart.Location Whe=xlLocationAsObject Name:=ActiveSheet.Name Set srs = Currentchart.SeriesCollection.NewSeries srs.XValues = myX srs.Values = myY btw is srs.Values = myY the right way to do this? Running my macro creates a chart but the Values are gone! With my first approach with myX and myYIDV defined manually (insert-names-define) using the disputed FORSKYVNING it worked fine. I`m lost -- hk ----------------------------------------------------------------------- hke's Profile: http://www.excelforum.com/member.php...nfo&userid=155 View this thread: http://www.excelforum.com/showthread.php?threadid=27411 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting email address names in a range of cells to real names | Excel Worksheet Functions | |||
using the Excel generic worksheet names instead of user-given names in code | Excel Discussion (Misc queries) | |||
Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
return all worksheet tab names and chart sheet tab names in report - an example | Excel Programming | |||
Change names of files in a folder to match names in Excel Column | Excel Programming |