| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dim SheetName in chart plot
How would I Dim the name of the current sheet, obviously Sheet1 is not
my sheet name ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R4C1:R14C1" Thanks in advance -mike *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dim SheetName in chart plot
Hello Mike, If by current you mean the active worksheet then... ActiveChart.SeriesCollection(1).XValues = "=" & ActiveSheet.Name "!R4C1:R14C1" Sincerely, Leith Ros -- Leith Ros ----------------------------------------------------------------------- Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846 View this thread: http://www.excelforum.com/showthread.php?threadid=50306 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Plot lines between plot points on a line chart | Charts and Charting in Excel | |||
| Auto insert sheetname into chart title? | Excel Worksheet Functions | |||
| plots sent to to a chart tab do not show plot & I loss the plot | Charts and Charting in Excel | |||
| Automatically update SheetName in workbook sub if SheetName changes | Excel Discussion (Misc queries) | |||
| how to plot a polar chart / plot | Charts and Charting in Excel | |||
Linear Mode
