Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
finding data for charts
Hi, I have a list of data which is set out as a name in cell a1 (say j
bloggs) and cells b1 to g1 contains data that needs to go into a chart,at the moment I plan to open a sheet for each name and plaste link the whole list on each sheet and build a chart on each sheet by sourcing the data from the list against each name. the problem is if they change the order of the names by adding one or removing one, I will have to rebuild all the links, is there a way I can pick up the data by locating the name and picking up the data linked in that row and either pasting it to a fixed place on the sheet where the chart would pick it up, or load direct into chart. Can any one help please, although it sounds like atall order. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding data | Excel Discussion (Misc queries) | |||
finding unmatched data | Excel Worksheet Functions | |||
Finding max row containing data... | Excel Discussion (Misc queries) | |||
finding data | Excel Worksheet Functions | |||
Finding duplicate data | Excel Worksheet Functions |