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.

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

How to Chart the Frequency of a Data Set on Excel. Plotting the frequency of data falling within numeric ranges illustrates the diversity of your data. As an example, a teacher might wish to ...