|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 20th, 2010, 08:55 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
Multiple Charts-Multiple Tabs
I have multiple charts on multiple tabs within an excel worksheet. Is there
anyway to source those charts to the tab name without resourcing the charts manually? Right now I am going to source data and sourcing them to the right tab name, I have over 500 charts that I have to resource. Anyone got any ideas? Thanks Nick Anderon 
|
|
#2
January 21st, 2010, 08:13 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Multiple Charts-Multiple Tabs
I get the fact that you have lots of worksheets with charts (one or more?)
on each of them No sure I understand the what you want to do. Move the charts? or move the data? If you click on a data series in the chart and look in the Formula Bar you will see something like =SERIES(,Sheet2!$A$1:$A$5,Sheet2!$B$1:$B$5,2) so the worksheet name is already part of the specs. Would love to help but your needs are not clear to me - want to give more info? best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Nick Anderson" wrote in message ... I have multiple charts on multiple tabs within an excel worksheet. Is there anyway to source those charts to the tab name without resourcing the charts manually? Right now I am going to source data and sourcing them to the right tab name, I have over 500 charts that I have to resource. Anyone got any ideas? Thanks Nick Anderon
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
