Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select number of rows in a graph?
Hi All, I create a variable which counts the number of rows as 'NumRows' and need to use it in the following vb: ActiveChart.SetSourceData Source:=Sheets("Net Sales").Range("A1:AD*INSERTROWSHERE*"), _ PlotBy:=xlColumns How do I add the variable in this section? Thanks -- cratediggah ------------------------------------------------------------------------ cratediggah's Profile: http://www.excelforum.com/member.php...o&userid=30363 View this thread: http://www.excelforum.com/showthread...hreadid=500166 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
graph based on the city i select in a particular cell | Charts and Charting in Excel | |||
Select last data in column for a graph | Charts and Charting in Excel | |||
Select Large Number of Rows | Excel Discussion (Misc queries) | |||
Is it possible to Select Data on a Graph/Zoom to it in the Spreads | Excel Discussion (Misc queries) | |||
Unable to select rows in the repeat rows on top option | Excel Discussion (Misc queries) |