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 - Pulling Out a Pie Slice & Formatting Chart Data Series

- How To Install Windows Server 2012 On VirtualBox
- How To Bypass Torrent Connection Blocking By Your ISP
- How To Install Actual Facebook App On Kindle Fire
6/27/2011 11:39:17 AM

Pulling Out a Pie Slice

A pie chart is an effective and easily understood chart type for comparing parts that make up a whole entity, such as departmental percentages of a company budget. You can call attention to individual pie slices that are particularly significant by moving them away from the other pieces, or exploding the pie. Not only will this make a visual impact, it will also restate the values you are graphing.

Explode a Pie Slice

Select a pie chart.

To explode a single slice, double-click to select the pie slice you want to explode.

Drag the slice away from the pie.


Release the mouse button.

You can select a pie slice to make it stand out. Because a pie chart has only one data series, clicking any slice selects the entire data series. Click a second time to select a specific slice.


Undo a Pie Explosion

Select a pie chart.

Drag a slice toward the center of the pie.



Release the mouse button.

Formatting Chart Data Series

If you want to further enhance a chart, you can insert a picture in a chart so that its image occupies a bar or column. You can use the Format Selection button to open the Format dialog box and change Fill options to format a chart data series with a solid, gradient, picture, or texture fill. In addition, you can also change a chart data series with a border color, border style, shadow, and 3-D formats, which include bevel, depth, contour, and surface styles.

Format a Chart Data Series

Select the chart series you want to modify.

Click the Format tab under Chart Tools.

Click the Format Selection button.


Select the options you want:

  • Series Options to change the gap width and depth (for 3-D charts), or series overlap (for 2-D charts).

  • Shape to change the shape to a box, pyramid, cone, or cylinder (for 3-D charts).

  • Fill to remove or change the fill, either solid color, 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.

Click Close.

Other -----------------
- Microsoft Excel 2010 : Creating and Modifying Charts - Changing Chart Labels
- Visual Basic 2010 : Understanding the .NET Thread Pool & Threads Synchronization
- Visual Basic 2010 : Processes and Multithreading
- Visual Basic 2010 : Implementing Query Interceptors
- Microsoft Visio 2010 : Adding Sophistication to Your Drawings - Adding ScreenTips and Comments
- Microsoft Visio 2010 : Adding Sophistication to Your Drawings - Positioning Shape Text
- Monitoring and Maintaining Windows 7 : Using Event Viewer
- Monitoring and Maintaining Windows 7 : Setting Up Task Scheduler
- Visual Basic 2010 : Implementing and Consuming WCF Data Services - Implementing Service Operations
- Visual Basic 2010 : Consuming WCF Data Services
 
 
Top 10
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 2) - Wireframes,Legends
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 1) - Swimlanes
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Formatting and sizing lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Adding shapes to lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Sizing containers
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 3) - The Other Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 2) - The Data Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 1) - The Format Properties of a Control
- Microsoft Access 2010 : Form Properties and Why Should You Use Them - Working with the Properties Window
- Microsoft Visio 2013 : Using the Organization Chart Wizard with new data
- First look: Apple Watch

- 3 Tips for Maintaining Your Cell Phone Battery (part 1)

- 3 Tips for Maintaining Your Cell Phone Battery (part 2)
programming4us programming4us
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
 
programming4us
Natural Miscarriage
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Game Trailer