Home |
Search |
Today's Posts |
#1
|
|||
|
|||
is it possible to embed and sort charts?
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? |
#2
|
|||
|
|||
Create the charts using a different named formula for each chart (see
Dynamic Charts http://www.tushar-mehta.com/excel/ne...rts/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 In article , says... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ability to embed a macro within a csv | Excel Discussion (Misc queries) |