is it possible to embed and sort charts?

[Ross]

e.g.

name size length 0min 3min 10min chart
A 3 5 1 10 3
B 5 2 2 4 3
C 4 3 3 9 6
....


Is it possible to plot a chart of 0 to 10 mins for each entity and then
later when i sort the data (say, by size) that the chart will be sorted
accordingly?

 

[Tushar Mehta]

Create the charts using a different named formula for each chart (see
Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html)

Example 4 shows how to plot one column out of a multi-column data set.
Adapt it to plot one row out of a multi-row data set.

Now, the first chart will always show the contents of the top row, the
2nd chart those of the 2nd row, etc.

Hence, if you sort the data the charts will appear to sort themselves.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions