Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours

Q&A

Q1:	When I created a chart, I selected the totals row and didn't get the results I wanted. How can I fix this?
A1:	When you create a chart, make sure the range you select includes the labels, but not the totals. If you are charting the totals, be sure to select only the total rows, and not the data that created them.
Q2:	My chart is plotted in rows and looks different from what I expected. What should I do next?
A2:	Sometimes when Excel produces a chart from a highlighted range, the chart is backward. The data series appears where categories should be, and vice versa. Excel makes a guess based on your selected data. If you have more columns than rows, the columns become the categories on the x-axis. If you have more rows than columns, the rows ...