Very good tip, Susan.
I tried to follow your instracction with my always a bit extrange Mac and 1) I could not find how to create a Text box 2) Inside a form, I could not create the cell reference (steps 2 and 3)
Could you help?
Discussion on:
View:
Show:
I don't run a Mac at all, so I'm unable to check the actual steps. Maybe a Mac user will check in and take pity on us! 
I don't wish to sound negative but there are a number of limitations with this approach.
1) The contents of a text box do not update if you add or remove lines. Therefore if you add more months you will have to update the references.
2) Susan is using the position of the boxes to indicate whether the sales are up or down. However the position of the boxes is "hard-coded" so if the data changes you have to reposition them. It may be just as easy to just write your comments into the text boxes.
If you use the references as the values in a legend the graph won't be quite as dramatic but it will continue to be correct if you add or remove rows..
1) The contents of a text box do not update if you add or remove lines. Therefore if you add more months you will have to update the references.
2) Susan is using the position of the boxes to indicate whether the sales are up or down. However the position of the boxes is "hard-coded" so if the data changes you have to reposition them. It may be just as easy to just write your comments into the text boxes.
If you use the references as the values in a legend the graph won't be quite as dramatic but it will continue to be correct if you add or remove rows..
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
