Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Noob Question Probably! :S
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Noob Question Probably! :S
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/p...cle.asp?ID=518 -- Robin Hammond www.enhanceddatasystems.com "LHUK" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Noob question | Excel Worksheet Functions | |||
Noob question | New Users to Excel | |||
Noob question | Excel Discussion (Misc queries) | |||
nOOb formulas question | Excel Discussion (Misc queries) | |||
Noob question - Worksheet_Change | Excel Programming |