| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Changing Sheets in chart
I need to be able to change the sheet reference in a chart by selecting a cell that has the sheet name. Each sheets data are in the same cells. I just need to reference different sheets. Example: if the current values are referenced by =Sheet1!$B$3:$B$8 then I need to be able to change Sheet1 to Sheet 2 without changing the other data example: =Sheet2!$B$3:$b$8 or =Sheet5!$B$3:$b$8 -- DBDEZYNE ------------------------------------------------------------------------ DBDEZYNE's Profile: http://www.excelforum.com/member.php...o&userid=27095 View this thread: http://www.excelforum.com/showthread...hreadid=466120 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Activating a Chart object | Charts and Charting in Excel | |||
| footer for chart sheets | Excel Discussion (Misc queries) | |||
| Chart sheets cause data sheets to be blank | Charts and Charting in Excel | |||
| changing proportion of chart and data table | Charts and Charting in Excel | |||
| Changing chart orientation | Charts and Charting in Excel | |||
Threaded Mode
