Cyberdude
05-03-2006, 10:49 AM
I just became aware that I can use an Excel (2003) ?list? in a chart Series formula. Doing so has a similar function to using a range with a defiined name in the Series formula so that you can add data to be plotted without altering the Series formula. However, I am completely clueless about using Excel lists.
My first question is, once I have defined a list, how to I undefine or delete the definition so that the list doesn?t exist anymore?
My second question is, how do I make it clear that I want a specific chart Series formula to use the list (or to stop using it)? I have an existing test chart whose Series formula referred to a range of data, say, B1 to B20. Then I created a list for cells B5 to B20. Nothing happened. So I tried to change the list (by dragging the upper border) to include cells B1 to B4. If it had worked, the list would have changed from B5 to B20 to become B1 to B20. But Excel wouldn?t let me make the change. So I decided to create a new list overlaying the original list. Excel wouldn?t let me do that.
Is anyone familiar with this application of lists to charts?
My first question is, once I have defined a list, how to I undefine or delete the definition so that the list doesn?t exist anymore?
My second question is, how do I make it clear that I want a specific chart Series formula to use the list (or to stop using it)? I have an existing test chart whose Series formula referred to a range of data, say, B1 to B20. Then I created a list for cells B5 to B20. Nothing happened. So I tried to change the list (by dragging the upper border) to include cells B1 to B4. If it had worked, the list would have changed from B5 to B20 to become B1 to B20. But Excel wouldn?t let me make the change. So I decided to create a new list overlaying the original list. Excel wouldn?t let me do that.
Is anyone familiar with this application of lists to charts?