Moving Charts from One Worksheet to Another in Excel 2007:-

You can combine charts from many worksheets into a single dashboard by moving the charts from their original locations.

If your sales data is on a sales worksheet, for example, you can build the chart on the sales worksheet. When the chart is selected, you choose Move Chart from the Design ribbon. 7 You can then choose to move the chart to a different worksheet. Look into the Figure (given below).



(You use the Move Chart dialog to build a dashboard of charts on a single sheet.)

The chart continues to point to data on the original worksheet, but you end up with an uncluttered screen of just charts. Even though the charts are on a new worksheet, they still respond to data changes on the source worksheets.