#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 846
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 846
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
Dynamic Ranges: Speed Issue Sige Excel Worksheet Functions 5 December 12th 05 09:28 PM
Indirect and dynamic ranges Sam Excel Worksheet Functions 3 January 24th 05 07:01 AM
Dynamic Formulas with Dynamic Ranges Ralph Howarth Excel Worksheet Functions 5 January 21st 05 08:44 AM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


All times are GMT +1. The time now is 05:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"