Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Use "labels in Formulas" for dynamic charting
Excel 2003 has a feature that I use and like; using the text at the
head of a column of data to refer to it. I use that extensively in in-cell formulae. However, it seems not to work in "in-chart" formulae. That is, I've used my best guess for the relevant syntax (=Worksheet! Label) for series values when creating a chart and it doesn't work. I've also tried a few variations on the theme. Has anyone done this successfully? Does anyone know for a fact that it doesn't work? If so, how did you come to the conclusion? It is frustratingly close to being an immensely useful tool - no more dynamically named ranges for charting! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Use "labels in Formulas" for dynamic charting
Bump!
Anyone? On Mar 6, 12:54*pm, wrote: Excel 2003 has a feature that I use and like; using the text at the head of a column of data to refer to it. I use that extensively in in-cell formulae. However, it seems not to work in "in-chart" formulae. That is, I've used my best guess for the relevant syntax (=Worksheet! Label) for series values when creating a chart and it doesn't work. I've also tried a few variations on the theme. Has anyone done this successfully? Does anyone know for a fact that it doesn't work? *If so, how did you come to the conclusion? It is frustratingly close to being an immensely useful tool - no more dynamically named ranges for charting! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Combine logical formulas "if", "and", "or" | Excel Discussion (Misc queries) | |||
Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
"accept labels in formulas" | Excel Discussion (Misc queries) |