#How to change text in excel legend update#
For example, if we go to the Salesperson column and change Alice to Anne, notice that both charts update accordingly. If we change anything in the base data, the charts will update. Then, go into another area and paste the chart by pressing Control+ V or right-clicking and choosing the Paste option.You can also copy a chart by pressing Control+ C or right-clicking and choosing the Copy option.Once created, you can use your cursor to move the graph anywhere you’d like.Age is too vague, so what we’d probably want to do is change it to something else. Generally, we’re going to want to make sure that the title is a very clear description of what the graph is showing.It will automatically create a title based on the information you provided.In general, you should never use a 3-D chart, unless you are showcasing a third dimension of data.As you hover over the options, Excel will give you a preview of what your information would look like in that chart.Excel tries to recommend charts based on the data you provide. There are a lot of different chart types.Go to the Insert tab on the ribbon and find the options for charts in the middle.We generally want to include the header rows because that will give us more information that we’ll feed into the graph.Select both columns of data for Sales Person and Age.Let’s suppose that we wanted to create a simple chart that shows the individual’s name and how old they are. We have a spreadsheet that shows a list of different salespeople in a company, their age in column C, and then the amount of sales that each one generated for each year for the past 10 years.