Logo
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
EPL Standings
 
 
Windows 7

Microsoft Excel 2010 : Creating and Modifying Charts - Changing Chart Labels

6/27/2011 11:35:49 AM
A legend is a set of text labels that helps the reader connect the colors and patterns in a chart with the data they represent. Legend text is derived from the data series plotted within a chart. You can rename an item within a legend by changing the text in the data series. If the legend chart location doesn’t work with the chart type, you can reposition the legend at the right, left, top or bottom of the chart or overlay the legend on top of the chart on the right or left side. Data labels show data values in the chart to make it easier for the reader to see, while a Data table shows the data values in an associated table next to the chart. If you want a customized look, you can set individual options using the Format dialog box.

Change the Chart Legend

Select the chart you want to modify.

Click the Layout tab under Chart Tools.

Click the Legend button, and then click one of the following:

  • None to hide the legend.

  • Show Legend at Right to display and align the legend on the right.

  • Show Legend at Top to display and align the legend at the top.

  • Show Legend at Left to display and align the legend on the left.

  • Show Legend at Bottom to display and align the legend at the bottom.

  • Overlay Legend at Right to position the legend on the chart on the right.

  • Overlay Legend at Left to position the legend on the chart on the left.

  • More Legend Options to set custom legend options.


Change Chart Data Labels

Select the chart you want to modify.

Click the Layout tab under Chart Tools.

Click the Data Labels button, and then click one of the following:

  • None to hide data labels.

  • Show to display data labels centered on the data points.

  • More Data Label Options to set custom data label options.

The available options vary depending on the select chart.


Show or Hide a Chart Data Table

Select the chart you want to modify.

Click the Layout tab under Chart Tools.

Click the Data Table button, and then click one of the following:

  • None to hide a data table.

  • Show Data Table to show the data table below the chart.

  • Show Data Table with Legend Keys to show the data table below the chart with legend keys.

  • More Data Table Options to set custom data table options.


Other -----------------
- 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
- Visual Basic 2010 : Implementing WCF Data Services
- Microsoft Visio 2010 : Adding Sophistication to Your Drawings - Orienting Shape Text
- Microsoft Visio 2010 : Adding Sophistication to Your Drawings - Orienting Shapes on the Page
- Microsoft Visio 2010 : Adding Text to Shapes & Creating and Formatting Text Boxes
- Monitoring and Maintaining Windows 7 : Using System Configuration
- Using Windows 7 Tools to Discover System Information
- Optimizing Windows 7 with Performance Monitor (part 3)
- Optimizing Windows 7 with Performance Monitor (part 2) - Utilizing Customized Counters in Performance Monitor & Managing Performance Monitor Properties
- Optimizing Windows 7 with Performance Monitor (part 1) - Using Resource Monitor
- Visual Basic 2010 : Reflection - Generating Code at Runtime with Reflection.Emit
- Visual Basic 2010 : Reflection - Invoking Code Dynamically
 
 
Most view of day
- Evaluating Applications for Windows 7 Compatibility : The Application Compatibility Toolkit (part 4) - Resolving Application Compatibility Issues with Shims
- Microsoft PowerPoint 2010 : Creating New Slides (part 1) - Creating New Slides from the Outline Pane
- Microsoft Visio 2010 : Creating Web Pages from Visio Drawings (part 2) - Exploring Visio-Generated Web Pages
- Developing with SharePoint 2010 (part 1) - Platform Development Tools, Development Server Configuration
- Windows Phone 7 : Running Silverlight Projects in the Browser (part 2)
- Understanding Network Services and Active Directory Domain Controller Placement for Exchange Server 2007 : Examining DNS Components
- Microsoft Dynamic AX 2009 : Working with .NET Business Connector (part 1) - Processing Requests and Responses
- Games and Windows 7 : Using the Games Explorer (part 4) - Managing Your Game Controllers and Other Game-Related Hardware
- Microsoft Dynamics CRM 2011 : Using Advanced Find (part 2) - Organizing and Formatting Advanced Find Results
- Maintaining Desktop Health : Understanding the Windows System Assessment Tool
Top 10
- Windows Server 2012 : DHCP,IPv6 and IPAM - Exploring DHCP (part 3) - Creating IPv4 DHCP Scopes
- Windows Server 2012 : DHCP,IPv6 and IPAM - Exploring DHCP (part 2) - Installing DHCP Server and Server Tools
- Windows Server 2012 : DHCP,IPv6 and IPAM - Exploring DHCP (part 1)
- Windows Server 2012 : DHCP,IPv6 and IPAM - Understanding the Components of an Enterprise Network
- Microsoft OneNote 2010 : Using the Research and Translate Tools (part 3) - Translating Text with the Mini Translator
- Microsoft OneNote 2010 : Using the Research and Translate Tools (part 2) - Translating a Word or Phrase with the Research Pane
- Microsoft OneNote 2010 : Using the Research and Translate Tools (part 1) - Setting Options for the Research Task Pane, Searching with the Research Task Pane
- Microsoft OneNote 2010 : Doing Research with Linked Notes (part 2) - Ending a Linked Notes Session, Viewing Linked Notes
- Microsoft OneNote 2010 : Doing Research with Linked Notes (part 1) - Beginning a Linked Notes Session
- Microsoft OneNote 2010 : Doing Research with Side Notes (part 3) - Moving Side Notes to Your Existing Notes
 
 
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
2015 Camaro