Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Referencing worksheet CODENAME in a chart object.
Hi all,
I have an excel chart (generated by the Chart Wizard) that references the worksheet NAME. For example, when i right click on chart, and select 'Source Data' i see the 'Data Range' reference the worksheet NAME as follows: ='Main Menu'!$D$13:$D$14,'Main Menu'!$E$13:$E$14 But the 'Main Menu' worksheet has a CODE NAME of of "Main". I've tried numerous permutations but i just cannot get this chart's Data Range to reference the worksheet CODE NAME instead. Can anyone help? Thanks |
#2
|
|||
|
|||
How about:
ActiveChart.SetSourceData Source:=Main.Range("d13:e14") When I recorded a macro, the range was combined into one reference. Even this way worked: ActiveChart.SetSourceData Source:=Main.Range("A1:A21,C1:C21"), _ PlotBy:=xlColumns Bing wrote: Hi all, I have an excel chart (generated by the Chart Wizard) that references the worksheet NAME. For example, when i right click on chart, and select 'Source Data' i see the 'Data Range' reference the worksheet NAME as follows: ='Main Menu'!$D$13:$D$14,'Main Menu'!$E$13:$E$14 But the 'Main Menu' worksheet has a CODE NAME of of "Main". I've tried numerous permutations but i just cannot get this chart's Data Range to reference the worksheet CODE NAME instead. Can anyone help? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove empty chart plots from linked worksheet charts | Charts and Charting in Excel | |||
Chart Wizard "as object in:" turned off | Excel Discussion (Misc queries) | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
How To Refresh Chart Data Without Calculating The Worksheet | Charts and Charting in Excel | |||
Can't save chart as object in current sheet | Charts and Charting in Excel |