If you have a formula somewhere that relies on the whole column in a table, then if you add or remove rows in the table, the formula will update without any effort on your part. If you don't want the total (it might overwhelm the rest of the data, simply select and delete the total columns in the chart, or select only the first four columns of the table before selecting the chart. Now select the table, or a cell within the table, and insert a column chart. It's a little overformatted, but you can select it and choose a less (or more!) formatted style. The Table now has special formatting, with a colorful header row and alternating bands of color. The dialog will ask if your range has headers, which it does (Week, A, B, C, Total). Nothing to be scared of, Tables are pretty powerful. It won't insert anything, but it will convert your ordinary range of data into a special data structure known as a Table. Select this range of data, and on the Insert ribbon tab, click Table. Excel charts work by plotting rows and columns of data, not just a big long row.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |