Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.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 |
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 ranges | Excel Worksheet Functions | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |