Edit your horizontal chart data in Excel 2007 with a variety of available tools. Change the data, format, titles and scale of your scatterplot's horizontal axis.

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.

We need to change that reference to the dynamic ranges we just created, as follows: In the chart, right-click any column. From the resulting submenu, choose Select Data.

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.

If you have uneven distribution of data in your Excel chart, here is a better way to change the automatic axis settings.

Learn how to use Excel’s Allow Edit Ranges feature to assign editable cells, protect data, and streamline collaboration in shared workbooks.

Learn how to show charts with hidden data cells in Excel. When there is data that is hidden in your table, Excel will not show that information in the chart.

Excel 2016's many new features include six new chart types. Here we cover Histogram, Pareto, and Waterfall, which cover statistical, trend, and other relationships.

Learn how to create Gantt charts in Microsoft Excel spreadsheets to provide visual representations of your data for easy analysis and ...

You don't need Microsoft Excel to chart data in an existing Excel file; you can simply import that data and chart it entirely in Microsoft Word. Follow these steps: ...