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.

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.

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

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.

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 ...

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.

Charts are great for showing comparisons and trends. In this tutorial, we will explain how to apply layouts and styles in a chart in Excel.

Learn how to make amazing informative Excel charts that look beautiful and captivate your audience. Professionally display your data in ...

It's time to dump the pie charts and move to donuts or even waterfalls to show off your data in ways people can better grasp.

When plotted on an Excel Scatter Chart, these data points will form a total of four circles, effectively converting a scatter chart into a bull’s-eye chart. Your updated table containing the ...