3 cells are named together - how refere to them in one chart reference field (a seriescollection(1)

M

Marie J-son

Hi,

I have three cells named and want to use that name in a vba chart procedure
for a xl3DColumnStacked chart

ActiveChart.SeriesCollection(1).Values = sheet1.Range(scol1v)

I used in the procedure:
Dim scol1v As String
Let scol1v = "ThreeValues"

Meaningless note:
I used sheet1 as Name and CodeName

In the excel GUI you find the name "ThreeValues" is defined as this
reference:
'sheet1'!$A$1;'sheet1'!$A$4;'sheet1'!$A$6

I thougt it just was to specify the sheet + name, but the debbugger doesn't
like that. what am i doing wrong? Shall I use array() or something? Please
give me a syntax or procedure that works that I can look at...

Regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

3 cells are named - how to refere to them in one reference field in a chart 2
Automatize chart building 1
Setting the Chart name as the text from a cell. 2
Using Range names in selecting chart series. 1
How to change weight of line in XY chart 3
Help using indirect addressing in chart series 2
Help: 1004 Method 'Charts' of Object '_Global' failed 0
Help: 1004 Method 'Charts' of Object '_Global' failed 3

Top