For additional information, see these Web resources: Allen Wyatt With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author.
He is president of Sharon Parq Associates, a computer and publishing services company. Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results.
Enter any new data to the table on which the chart is based.2. Click anywhere on the selection border around the cells. Drag the selection toward the chart and drop it on the chart.5. It's as if the data is simply being moved from the original cells to new cells "behind" the chart. When entering numerical data in Excel, it helps to format it according to the type of data it is. percentage, currency, date, or text—helps drive consistency and accuracy in displaying and working with your data.This works because the names you defined in steps 6 and 10 refer to a formula that calculates the extent of data in columns A and B of your worksheet.There are many other ways that you can create dynamic ranges, depending on the characteristics of the data you are using.Another approach is to add new data to the range not at the end, but somewhere within the range.
For instance, you may have some data that represents a time period, such as 11/1 through 11/13, and you create a chart based on those dates.It is interesting to note that for some types of data—such as those based on dates—Excel will automatically sort the data by date as it presents it in the chart, but not in the data table itself.You can always use Excel's sort feature to reorder the data in the table, all without affecting what is presented in the chart.Excel shines at turning your data into charts—graphical representations of your data.You can easily create a chart based on a range of data in a worksheet.Still another approach is to create a "dynamic range." This approach works well if the data range you are charting is the only data on the worksheet.