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 : Editing Chart Data

- 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
7/3/2011 4:58:31 PM
You can edit chart data in a worksheet one cell at a time, or you can manipulate a range of data. If you’re not sure what data to change to get the results you want, use the Edit Data Source dialog box to help you. In previous versions, you were limited to 32,000 data points in a data series for 2-D charts. Now you can have as much as your memory to store (New!). You can work with data ranges by series, either Legend or Horizontal. The Legend series is the data range displayed on the axis with the legend, while the Horizontal series is the data range displayed on the other axis. Use the Collapse Dialog button to temporarily minimize the dialog to select the data range you want. After you select your data, click the Expand Dialog button to return back to the dialog box.

Edit Data in the Worksheet

In the worksheet, use any of the following methods to edit cell contents:

  • To replace the cell contents, click the cell, type the data you want to enter in the cell. It replaces the previous entry.

  • To edit the cell content, double-click the selected cell where you want to edit.

    Press Delete or Backspace to delete one character at a time, and then type the new data.

Press Enter to move the insertion point down one row or press Tab to move the insertion point right to the next cell.



You can plot data series from rows or columns. Select the chart, click the Design tab under Chart Tools, and then click the Switch Row/Column button. This switches between plotting the data series in a chart from worksheet rows or from columns.


Edit the Data Source

Click the chart you want to modify.

Click the Design tab.

Click the Select Data button on the Design tab under Chart Tools.



In the Select Data Source dialog box, use any of the following:

Important

Click the Collapse Dialog button to minimize the dialog, so you can select a range in the worksheet. Click the Expand Dialog button to maximize it again.

  • Chart data range. Displays the data range in the worksheet of the plotted chart.

  • Switch Row/Column. Click to switch plotting the data series in the chart from rows or columns.

  • Add. Click to add a new Legend data series to the chart.

  • Edit. Click to make changes to a Legend or Horizontal series.

  • Remove. Click to remove the selected Legend data series.

  • Move Up and Move Down. Click to move a Legend data series up or down in the list.

  • Hidden and Empty Cells. Click to plot hidden worksheet data in the chart and determine what to do with empty cells.

Click OK.

For Your Information: Displaying Hidden Data and Empty Cells in Charts

Hidden data in rows and columns of a worksheet is not displayed in a chart and empty cells are displayed as gaps. In the Select Data Source dialog box, you can click the Hidden and Empty Cells button to change the way Excel displays hidden data and empty cells in a chart. You can set options to show data in hidden rows and columns and show empty cells as a zero or connect data points with a line.

Other -----------------
- Microsoft Excel 2010 : Changing the Chart Background & Enhancing a Chart
- Microsoft Excel 2010 : Formatting Chart Text & Formatting Line and Bar Charts
- Visual Studio 2010 : Building the Windows Container (part 3) - Creating a Multiple Document Interface
- Visual Studio 2010 : Building the Windows Container (part 2) - Adding menus and toolbars
- Visual Studio 2010 : Building the Windows Container (part 1) - Setting common form properties & Creating dialog boxes
- Microsoft Visio 2010 : Adding Labels to Flowcharts & Understanding Swimlane Diagrams
- Microsoft Visio 2010 : Selecting a Flowchart Type & Creating Flowcharts
- Automating the Windows 7 Installation : Choosing Automated Deployment Options (part 3) - An Overview of the System Preparation Tool and Disk Imaging
- Automating the Windows 7 Installation : Choosing Automated Deployment Options (part 2)
- Automating the Windows 7 Installation : Choosing Automated Deployment Options (part 1) - An Overview of the Microsoft Deployment Toolkit 2010
 
 
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