If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Dynamic ranges
I'm doing one thing wrong and I can't see the solution
I believe that my problem is defining the x-axis in the dynaminc range. I can get the number to start at the right point - however I'm getting blanks on the right side of the graph - like it thinks there are numbers to graph but there isn't. Does this make enough sense or do you need more detail |
#2
|
|||
|
|||
Dynamic ranges
I think we need more detail. Like what formula are you using for the
dynamic range. What content do you have in the cells. You could do a quick check by going to the Names dialog and placing you cursor in the control that contains the formula. This should then display the 'marching ants' around the range it will be using. Does this match what you expect? Cheers Andy Brad wrote: I'm doing one thing wrong and I can't see the solution I believe that my problem is defining the x-axis in the dynaminc range. I can get the number to start at the right point - however I'm getting blanks on the right side of the graph - like it thinks there are numbers to graph but there isn't. Does this make enough sense or do you need more detail -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Dynamic ranges
I figure it out - the main problems is that I couldn't see everything in the
Chart - Source Data - Series - Values (input box). One very minor change and it worked. I think that this is feature, in Excel, is sooo cool. "Andy Pope" wrote: I think we need more detail. Like what formula are you using for the dynamic range. What content do you have in the cells. You could do a quick check by going to the Names dialog and placing you cursor in the control that contains the formula. This should then display the 'marching ants' around the range it will be using. Does this match what you expect? Cheers Andy Brad wrote: I'm doing one thing wrong and I can't see the solution I believe that my problem is defining the x-axis in the dynaminc range. I can get the number to start at the right point - however I'm getting blanks on the right side of the graph - like it thinks there are numbers to graph but there isn't. Does this make enough sense or do you need more detail -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|