How to edit values in Excel spreadsheet

Asked By Rachel Russel 10 points N/A Posted on - 01/27/2012

In Excel 2007 charts whenever I put the pointer over a point of the chart an info window with yellow background appears saying “Series…. Point…..?” How can I edit this value in a spreadsheet?

• Status: Open
• Question Views: 1097
• Answer Count: 3
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by anjanamanoj

Go To Solution

Answered By CapeSteve 15 points N/A #104685

How to edit values in Excel spreadsheet

 

There are various types of chart in Microsoft office Excel 2007. To experience your problem I have taken a Bar2D chart. A blank chart appears. Now you need to do a right click on chart and click on ‘select data’. A window appears. First you can set the data range of your choice then add series of your choice by click on button ‘ADD’ on the same window in the section ‘Legend Entries’. After click on ‘ADD’ another window appears with extra features. By this window you can able to edit the series and create a chart.

Hope this will help you.

About CapeSteve

Questions
1

Answers
59

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 01/27/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By anjanamanoj 0 points N/A #104686

How to edit values in Excel spreadsheet

Assume we have a chart like this on Incentives of few employees

Select an area somewhere on the graph and right click.. You will get options as shown below…Highlight “ Select Data” and click

You will be taken to source data as shown below

 

In the legend entries, you can either edit the existing entry or create a new one. When you press edit, you will be prompted to enter a text or the reference of a cell which contains the text. In the example below,instead of “Incentives”, I have selected the content of $D$13 to be displayed

The outcome of this selection would be

Similiarly you can change the texts for the employee name too

Hope this helps

About anjanamanoj

Questions
0

Answers
1

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 03/18/2012
• Question Category: MS Excel

Answered By Rachel Russel 10 points N/A #104687

How to edit values in Excel spreadsheet

Many thanks Anjanamanoj!

You're solution with photos and examples are really great. Thank you for the help. Now I know what to do.

Thanks TechyV.

About Rachel Russel

Questions
11

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/05/2012
• Question Category: MS Excel