Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have just worked through an excelent example for creating a chart
directly from a formula on www.jkp-ads.com. This at last has got my head around Names (I think) eg. a name defined "sheet1!Top_left" =sheet1!$a$1 cannot be used or seen on another sheet a name defined "Top_left" =sheet1!$a$1 can be used on all sheets and always refers to sheet1 a name defined "Top_left" =indirect("a1") can be used on all sheets and refers to a1 on the same sheet as the name call. The bit I need help on (and sorry for the waffle) is what Labels are and how do I use them. Pointers to other reading would be welcome. The xlhelp and ms sites haven't realy helped. What I am hoping they do is make some fairly involved sheets I have easier for others to decipher . Thanks in advance for any help or suggestions Cheers RES |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stock High-Low-Close Chart | Charts and Charting in Excel | |||
How do I put two names on a mailing list at the same address witho | Excel Discussion (Misc queries) | |||
Creating names | Excel Discussion (Misc queries) | |||
HOW DO I ENTER TWO NAMES IN ONE ROW FOR ONE ADDRESS FOR LABELS | Excel Discussion (Misc queries) | |||
Relative addressing using names or labels in formulas? | Excel Worksheet Functions |