O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working with Embedded Chart Objects

As mentioned, a chart embedded on a worksheet is an object, just like an embedded picture, calendar control, or anything else that you might add to your worksheet via the Insert, Object command. You can assign a macro to it, and move it forward or back relative to other objects, by using the same kinds of actions that you would apply to other kinds of objects. For details about working with objects, see Chapter 9.

The one important point you have to remember about working with a chart object is that to select it as an object, you need to hold down Ctrl while you click. Otherwise, you'll be selecting an element of the chart, not the entire object. When you've selected the object, white (clear) handles appear around ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required