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.

Here is a better way to change the automatic axis settings: Open the Excel file containing the chart. Click a value in the chart’s vertical axis to select it. Right-click the selected vertical axis.

Enable Chart Tool options by clicking anywhere within an Excel 2007 or 2010 chart whose information you want to modify. Click Design on the main menu, then Layout and finally, select Axis Title or ...

When you use Excel's Chart Wizard to create a chart, by default the chart takes on the number formats used in the worksheet that includes the charted data. Mary Ann Richardson shows you a way to ...