excell charts

mal · May 1st, 2002, 05:15 PM

how to change the range of cells, used on a chart, through a macro

[ This Message was edited by: mal on 2002-05-01 16:16 ]

Qroozn · May 1st, 2002, 07:05 PM

hope this helps a bit

chartrange = inputbox ("enter chart range here")
ActiveChart.SetSourceData Source:=Sheets("Sheet1").RangechartrangePlotBy _
:=xlColumns

Qroozn · May 1st, 2002, 07:07 PM

goto record new macro, then click on your chart. now goto data/change data source, and change it here.
now stop the macro recording, and look at your source code.

[ This Message was edited by: Qroozn on 2002-05-01 18:08 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 1st, 2002, 05:15 PM	#1
mal New Member Join Date: Apr 2002 Posts: 4	how to change the range of cells, used on a chart, through a macro [ This Message was edited by: mal on 2002-05-01 16:16 ]

May 1st, 2002, 07:05 PM	#2
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	hope this helps a bit chartrange = inputbox ("enter chart range here") ActiveChart.SetSourceData Source:=Sheets("Sheet1").RangechartrangePlotBy _ :=xlColumns

May 1st, 2002, 07:07 PM	#3
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	goto record new macro, then click on your chart. now goto data/change data source, and change it here. now stop the macro recording, and look at your source code. [ This Message was edited by: Qroozn on 2002-05-01 18:08 ]