Online Test Banks
Score higher
See Online Test Banks
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Editing a Chart’s Data Source in Excel 2007

3 of 12 in Series: The Essentials of Working with Charts in Excel 2007

After you create a chart in Excel 2007, you may need to change the range of the source data that is the basis for the chart. The Select Data Source dialog box lets you choose a different source range for an existing chart. You also can use this dialog box to switch the row and column values, change the order of the data series used in the chart, and indicate how to deal with hidden and empty cells in the data range being charted.


Select the chart and then click the Select Data button in the Data group on the Chart Tools Design tab.

Excel opens the Select Data Source dialog box.


Click and drag in the worksheet to select the new data range.

The Select Data Source dialog box collapses so you can easily see your data. You also can use the Collapse/Expand button to the right of the Chart Data Range box to select the range and return to the dialog box.


Release the mouse button.

The Select Data Source dialog box reappears.


Click OK.

The Select Data Source dialog box closes, and the chart updates to display the new data source.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus

Inside Sweepstakes

Win an iPad Mini. Enter to win now!