S
stendahl_jones
Hi! I am writing a macro for an Excel spreadsheet. I am trying to make charts
that are variable in the sense that the program searches the spreadsheet for
certain details that are supposed to be in the charts. Thus I cannot use
fixed cell reference. Now my y-axis is wrong since I do not know how to
choose the appropriate columns that are supposed to be in the chart. Is there
any way of defining a range for a chart in various sections? By this I mean
that you can specify that first you want the area from A1
1 and then you
want to include the area from F1:J1? My code now is:
ActiveChart.SetSourceData Source:=Sheets("Indata").Range(rng1.Address,
rng1.Offset(i, j).Address), PlotBy:=xlColumns
and it is ...Range(.....) that is wrong. Help needed as well as wanted!
Please!
that are variable in the sense that the program searches the spreadsheet for
certain details that are supposed to be in the charts. Thus I cannot use
fixed cell reference. Now my y-axis is wrong since I do not know how to
choose the appropriate columns that are supposed to be in the chart. Is there
any way of defining a range for a chart in various sections? By this I mean
that you can specify that first you want the area from A1
1 and then youwant to include the area from F1:J1? My code now is:
ActiveChart.SetSourceData Source:=Sheets("Indata").Range(rng1.Address,
rng1.Offset(i, j).Address), PlotBy:=xlColumns
and it is ...Range(.....) that is wrong. Help needed as well as wanted!
Please!