Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Dynamic Ranges: Speed Issue | Excel Worksheet Functions | |||
Indirect and dynamic ranges | Excel Worksheet Functions | |||
Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |