Dynamic ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
Back
Top