Hi guys,
Bear with me - im a complete noob when it comes to vba...i need to to a lot of graphs and i need to do it with a Do until loop.
The expression is:
ActiveChart.SeriesCollection(3).Values = "='Excel Tab 1'!R181C2:R181C13"
and I need to replace the cell reference with a variable like:
variable = 181
ActiveChart.SeriesCollection(3).Values = "='Excel Tab 1'!R - variable - C2:R181C13"
variable = variable + 1
What is the correct syntax for that?? I have tried " and :...no luck..
Thanx // JS
Dont you want the Collection(3) to be Collection(variable) as well ??
ActiveChart.SeriesCollection(3).Values = "='Excel Tab 1'!R " & variable & " C2:R181C13"
Otherwise only the last in the Loop will set the Values
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Thank you so much...it works...
Is it possible to name the chart with a variable. For example now i name every chart manually:
.ChartTitle.Characters.Text = "0"
but I would rather name it .ChartTitle.Characters.Text = (Value in the cell R1C & variable & )
Is it possible?
//JS
.ChartTitle.Characters.Text = Cells(R & variable &C1).Value should work...but nope...(as I mentioned before...im a noob...)
Cells do not take R & C. It's Cells(Row,Column), so in your case
AND start using CODE tags fom now on !! the # in the advanced editor.Cells(variable,1).value
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks