Noob Question Probably! :S

[Guest]

hi all sorry if this is a stupid question!

i am basically trying to make a macro so that as enter one row of data into
a spread sheet a graph will increase the data series in that range by 1. for
example so that as i enter the data on a daily basis it updates the graph:


ActiveChart.SeriesCollection(1).XValues = "='LI DB'!R8C1:R100C1"
ActiveChart.SeriesCollection(1).Values = "='LI DB'!R8C18:R100C18"
ActiveChart.SeriesCollection(2).XValues = "='LI DB'!R8C1:R100C1"
ActiveChart.SeriesCollection(2).Values = "='LI DB'!R8C9:R100C9"
ActiveChart.SeriesCollection(3).XValues = "='LI DB'!R8C1:R100C1"
ActiveChart.SeriesCollection(3).Values = "='LI DB'!R8C10:R100C10"

this is what ive got so far i guess i just need to workout what i need to do
to get the '100' part to '101' then '102' then '103' everytime i run the
macro.

im really sorry if im about as clear as mud, but any help is much
appreciated!

many thanks

LH

 

[Robin Hammond]

You don't need code to do this. Have a look at Jon Peltier's article about
dynamic named ranges in charts.

http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=518