You can change the spreadsheet data that AppleWorks charts. You can also change how AppleWorks interprets the data.
Adding new data to a chart Using rows or columns for chart series Using spreadsheet numbers as chart labels