Place the cost factors in column E, starting at row 3. Start your table in column F and place your years in row 2.
#HOW DO I CHANGE DATA IN EXCEL CHART SERIES#
On your data worksheet (the one without the chart I'll name the worksheet "Source Data"), the data is arranged with each year in a separate column and a series of cost factors in each row. 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 and you'll start casting about for ways to make the changes easier (and more reliably). 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 change the data range reference. You can use the tools on the Insert tab of the ribbon to quickly identify an entire data table or you can select a portion of a data table and use the same tools 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 kommentar(er)
