Sure, I can help you with that! In Excel 2007, you can use the
"Edit Data" feature to achieve this. Here are the steps:
- Select the line chart you want to edit.
- Click on the "Design" tab in the ribbon.
- Click on "Select Data" in the "Data" group.
- In the "Select Data Source" dialog box, click on the "Edit" button under "Legend Entries (Series)".
- In the "Edit Series" dialog box, click on the "Series Values" field.
- Click on the cell that contains the data you want to edit.
- Change the value in the cell to the desired value.
- Click on the "OK" button to close the "Edit Series" dialog box.
- Click on the "OK" button to close the "Select Data Source" dialog box.
Now, when you select a data point on the line chart and drag it up or down, it will change the data in the associated cell. This should work the same way as it did in Excel 2000.