Logo
programming4us
programming4us
programming4us
programming4us
Home
programming4us
XP
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Windows Phone
 
programming4us
Windows 7

Microsoft Excel 2010 : Creating and Modifying Charts - Selecting Chart Elements & Formatting Chart Elements

6/13/2011 5:46:54 PM

Selecting Chart Elements

Chart elements are the individual objects that make up a chart, such as an axis, the legend, or a data series. The plot area is the bordered area where the data are plotted. The chart area is the area between the plot area and the chart elements selection box. Before you can change or format a chart element, you need to select it first. You can select a chart element directly on the chart or use the Chart Elements list arrow on the Ribbon. When you select a chart, handles (small white circles) display around the window’s perimeter, and chart tools become available on the Design, Layout, and Format tabs. When you select an element in a chart, the name of the object appears in the Chart Elements list, which indicates that you can now edit it.

Select a Chart Element

Select the chart you want to change.

Click the Format or Layout tab under Chart Tools.

Click the Chart Elements list arrow.

Click the chart element you want to select.

When a chart object is selected, selection handles appear.

Timesaver

To select a chart object, click a chart element directly in the chart.



You can enlarge a chart object to select it. Increase the zoom percentage to enlarge your view before using the mouse pointer to select chart objects.

Formatting Chart Elements

Before you can format a chart element, you need to select it first. You can select a chart element directly on the chart or use the Chart Elements list arrow on the Ribbon. After you select a chart element, you can use the Format Selection button to open the Format dialog box, where you can change formatting options, including number, fill, border color and styles, shadow, 3-D format, and alignment. Formatting options vary depending on the selected chart element. In the same way you can apply shape fills, outlines, and effects to a shape, you can also apply them to elements and shapes in a chart.

Format a Chart Object

Select the chart element you want to modify.

Click the Format tab under Chart Tools.

Click the Format Selection button.
Select the options you want. The available options vary depending on the chart.

Some common formatting option categories in the left pane include the following:

  • Number to change number formats.

  • Fill to remove or change the fill color, either solid, gradient, picture, or texture.

  • Border Color or Styles to remove or change the border color and styles, either solid or gradient line.

  • Shadow to change shadow options, including color, transparency, size, blur, angle, and distance.

  • 3-D Format to change 3-D format options, including bevel, depth, contour, and surface.

  • Alignment to change text alignment, direction, and angle.

Click Close.


Apply a Shape Style to a Chart Object

Select the chart element you want to modify.

Click the Format tab under Chart Tools.

Click the Shape Fill, Shape Outline, or Shape Effects button, and then click or point to an option.

  • Fill. Click a color, No Fill, or Picture to select an image, or point to Gradient, or Texture, and then select a style.

  • Outline. Click a color or No Outline, or point to Weight, or Dashes, and then select a style.

  • Effects. Point to an effect category (Preset, Shadow, Reflection, Glow, Soft Edges, Bevel, or 3-D Rotations), and then select an option.


You can quickly access chart formatting options. Double-click a chart element to open a formatting dialog box (New!).

Other -----------------
- Microsoft Excel 2010 : Creating and Modifying Charts - Changing a Chart Type & Changing a Chart Layout and Style
- Microsoft Visio 2010 : Serialization with XAML
- Microsoft Visio 2010 : Custom Serialization
- Microsoft Visio 2010 : Connecting Shapes with Dynamic Connectors
- Microsoft Visio 2010 : Copying and Pasting Shapes & Connecting Shapes with Lines
- Microsoft PowerPoint 2010 : Working Together on Office Documents - Creating Office Documents on Windows Live
- Microsoft PowerPoint 2010 : Working Together on Office Documents - Setting Folder Permissions on Windows Live
- Visual Basic 2010 : XML Serialization
- Visual Basic 2010 : Objects Serialization (part 2) - Soap Serialization & Providing Serialization for Custom Objects
- Visual Basic 2010 : Objects Serialization (part 1) - Binary Serialization
 
 
Top 10 video Game
-   Call Of Duty: Black Ops III [PS4/XOne/PC] Zombies - Shadows of Evil Trailer
-   No Time To Explain [XOne/PC] Multiplayer Trailer
-   Bierzerkers [PC] Early Access Trailer
-   Downward [PC] Kickstarter Trailer
-   Grip [PS4/PC] Trailer
-   Hitman [PS4/XOne/PC] Debut Trailer
-   Gears of War: Ultimate Edition [XOne] Recreating the Cinematics Trailer
-   Gravity Falls: Legend of the Gnome Gemulets [3DS] Debut Trailer
-   Street Fighter V [PS4/PC] Ken Trailer
-   Doctor Who | Series 9 Teaser Trailer
-   Transformers: Devastation | Gameplay Trailer (SDCC 2015)
-   Tom Clancy's Rainbow Six Siege | Inside Rainbow #3 – The GIGN Unit
-   Final Fantasy XIV: A Realm Reborn 'Alexander' Video
-   SirVival Trailer
-   Blood Bowl II [PS4/XOne/PC] Overview Trailer
Popular tags
Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 windows Phone 7 windows Phone 8
programming4us programming4us
 
Popular keywords
HOW TO Swimlane in Visio Visio sort key Pen and Touch Creating groups in Windows Server Raid in Windows Server Exchange 2010 maintenance Exchange server mail enabled groups Debugging Tools Collaborating
programming4us programming4us
PS4 game trailer XBox One game trailer
WiiU game trailer 3ds game trailer
Trailer game
 
programming4us
Natural Miscarriage
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Game Trailer