![]() ![]() Name these two cells something like FromYear and ToYear. On the same sheet as the chart, create two input cells which will serve as "from" and "to" indicators. Let's say that your chart is embedded on a worksheet, but the worksheet is different than the one where the source data is located. One way to do this is with the use of named ranges and several worksheet functions. Make the changes often enough in the Chart Wizard, and you'll start casting about for ways to make the changes easier (and more reliably) than with the wizard. For instance, if you have a data table that includes several years worth of data, you may want to view a chart that is based on the first five years of data, and then change the data range so the chart refers to a different subset of the data. If you change the data range for your chart quite often, it can get tiresome to continually pull up the Chart Wizard and change the data range reference. The Chart Wizard can quickly identify an entire data table, or you can select a portion of a data table and use the Chart Wizard to create a chart based just on that portion. Excel is great when it comes to creating charts based on data in a data table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |