Home |
Search |
Today's Posts |
#1
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
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I move multiple tabs in multiple workbooks to a master? | Excel Worksheet Functions | |||
Average Over Multiple Sheet Tabs with Multiple Values | Excel Worksheet Functions | |||
Create multiple sheet tabs from multiple cells. | Excel Worksheet Functions | |||
How do I use VLOOKUP to ref multiple workbooks with multiple tabs? | Excel Discussion (Misc queries) | |||
arranging excel tabs (charts vs worksheets)in multiple rows/dimens | Charts and Charting in Excel |