Learn how to change, edit or rename a Data Series name in Microsoft Excel Graph or Chart without editing the original row or column name.

How to Change a Range in Microsoft Excel. When you copy a formula, referenced ranges automatically adjust according to the formula's new position unless the ranges use absolute references.

For example, you could show line graphs for temperature and humidity on top of each other. For this purpose, Excel lets you add a series of data to a chart and plot it on a second y-axis.

Are you constantly changing your Excel chart's data range as new information becomes available? Mary Ann Richardson shows how to set up the chart to automatically update as you add new rows of ...