Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart Names
Hi everyone,
I'm sorry if this is really simple but I just can't figure it out... I have a worksheet with three charts on it. I need to write some VBA to select each chart and ammend the axis settings on each one. So I figured the first thing to do is to name the charts so that I can specify which one to select in the VBA. But how do you name a chart???? When I click on a chart I get "Chart Area" in the name box, and I can't edit it! Thanks for any help, Tony M. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart Names
Hold the Ctrl key and click on the chart to select it.
Click in the Name Box, type a new name, then press the Enter key Tony M wrote: I have a worksheet with three charts on it. I need to write some VBA to select each chart and ammend the axis settings on each one. So I figured the first thing to do is to name the charts so that I can specify which one to select in the VBA. But how do you name a chart???? When I click on a chart I get "Chart Area" in the name box, and I can't edit it! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart Names
Debra, you're a wonder.
thanks v much Tony M. -----Original Message----- Hold the Ctrl key and click on the chart to select it. Click in the Name Box, type a new name, then press the Enter key Tony M wrote: I have a worksheet with three charts on it. I need to write some VBA to select each chart and ammend the axis settings on each one. So I figured the first thing to do is to name the charts so that I can specify which one to select in the VBA. But how do you name a chart???? When I click on a chart I get "Chart Area" in the name box, and I can't edit it! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reset chart names | Charts and Charting in Excel | |||
Names on a Bubble Chart | Charts and Charting in Excel | |||
chart legend names in a chart itself | Charts and Charting in Excel | |||
Chart names | Charts and Charting in Excel | |||
Using Defined Names in a Chart | Excel Discussion (Misc queries) |