Hi there,

Currently, I am doing a project where I have a list of names in colum A and other columns to the right (B, C, D....) that measure different values that correspond to a certain name in A. In another sheet, I would like to build charts comparing column A and column B, column A and column C and so on... each in descending order based on for example B then A, C then A.

How do I create a link between sheets so that I can update data in Sheet 1, and it will be carried over to Sheet 2 and automatically sorted in descending order and those changes be reflected in a chart? Can this actually be done in Excel?

Right now I have simply copied over two colums, used the sort Function to sort B then A and created a chart. But every time the information in Sheet 1 changes, I have to copy it over and sort and make the chart all over again in Sheet 2. This is useless to me!