How Excel Charts Work A chart has an x-axis range and a y-axis range to show the correlation between two different data sets. The x-axis is the horizontal category line.

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.

It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.