LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 13
Default dynamic ranges for charting

I saw another post with a similare title, but there was not enough info in
there to tell me if I am trying the same thing.

I want to have a column of data. Depending on the values in the column, I
will automatically calculate start and end rows for the data I want to
graph. If I paste in a new set of values, my formula to calculate the start
and end would automatically update and I would lkike the chart to
automatically update too.

I was able to create a single cell with an OFFSET() statement that
determines the position and height and width of my data to be graphed. When
I created a graph of that cell it did some crazy things, not just graphing
that singel value. So I think I'm on the right track trying to use OFFSET()
or ADDRESS() or something like that.

Thanks...


 
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 ranges Sam Excel Worksheet Functions 2 January 21st 05 07:46 PM
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 03:52 PM.

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"