Monday, September 10, 2012

Chart Objects in Excel 2007


Chart Object, What they are

                The Objects are the Vertical Axis or Values, Chart Title, Series Legend Entry, Horizontal Axis or Category, Series Total, and many other portions (objects).

                Click on the Blue Surround that will make sure that the Chart is selected as opposed to one of the Objects within the Chart. 

                If you hover over the White Area, where the Blue Boxes are this is the Chart Area object.
                If you hover over the Grey Lines inside of the Red Box they are the Vertical Axis Major Gridlines, they are associated with the Numbers at the Left or the Values and the Columns. 
                If you hover over the White Area within the Red Box, this is called the Plot Area.

                The Object in the second sample in the Black Box is the Vertical Access (Value).
                Inside the Red Box is the Chart Title.

                The Object in the Green Box is the Legend.
                The Object in the Purple Box is the Horizontal Axis (Category).

            These Objects will change as to the information that you have in your Chart.  If you have the Product as opposed to the Months then the Objects will reflect the Product information.  There are also ways that you can manipulate the Objects, Change the Color, Change the Background Color or add a Picture.

                I will show you how to do all of this later on in the Charts Lesson in the book.

No comments:

Post a Comment

[Valid Atom 1.0]