Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
dynamic ranges in excel 2007
i had some dynamic ranges working for charts in excel 2003 - now I have
'upgraded' to 2007 and the dynamic range for charts don't work. (they work when in compatibility mode, but not when save as new 2007 xls). Any ideas? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
dynamic ranges in excel 2007
How are you defining the ranges?
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "onzilla" wrote in message ... i had some dynamic ranges working for charts in excel 2003 - now I have 'upgraded' to 2007 and the dynamic range for charts don't work. (they work when in compatibility mode, but not when save as new 2007 xls). Any ideas? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
dynamic ranges in excel 2007
Range 'Refers To'
=OFFSET($A$1,0,0,COUNT($A:$A),1) the purpose of this, of course, would be that you can run that graph and have the range work automatically for different sized data sets.. without having to mannually re edit the range. Jono "Jon Peltier" wrote: How are you defining the ranges? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "onzilla" wrote in message ... i had some dynamic ranges working for charts in excel 2003 - now I have 'upgraded' to 2007 and the dynamic range for charts don't work. (they work when in compatibility mode, but not when save as new 2007 xls). Any ideas? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
dynamic ranges in excel 2007
If your purpose is ALWAYS to chart ALL the data in the range, then:
Make the range an Excel Table. The chart automatically changes as the table increases or contracts. I'll let Jon solve the OFFSET issue best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "onzilla" wrote in message ... Range 'Refers To' =OFFSET($A$1,0,0,COUNT($A:$A),1) the purpose of this, of course, would be that you can run that graph and have the range work automatically for different sized data sets.. without having to mannually re edit the range. Jono "Jon Peltier" wrote: How are you defining the ranges? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "onzilla" wrote in message ... i had some dynamic ranges working for charts in excel 2003 - now I have 'upgraded' to 2007 and the dynamic range for charts don't work. (they work when in compatibility mode, but not when save as new 2007 xls). Any ideas? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
dynamic ranges in excel 2007
I can't reproduce your issue. I entered your exact formula as the refers-to
formula for a range, then used the range in the series formula, and the series became dynamic, as expected. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "onzilla" wrote in message ... Range 'Refers To' =OFFSET($A$1,0,0,COUNT($A:$A),1) the purpose of this, of course, would be that you can run that graph and have the range work automatically for different sized data sets.. without having to mannually re edit the range. Jono "Jon Peltier" wrote: How are you defining the ranges? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "onzilla" wrote in message ... i had some dynamic ranges working for charts in excel 2003 - now I have 'upgraded' to 2007 and the dynamic range for charts don't work. (they work when in compatibility mode, but not when save as new 2007 xls). Any ideas? |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
dynamic ranges in excel 2007
Jon,
I am sorry to trouble you with this.. I figured out I was doing something else wrong. It is complex worksheet. How much do you charge for consulting per hour? "Jon Peltier" wrote: I can't reproduce your issue. I entered your exact formula as the refers-to formula for a range, then used the range in the series formula, and the series became dynamic, as expected. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "onzilla" wrote in message ... Range 'Refers To' =OFFSET($A$1,0,0,COUNT($A:$A),1) the purpose of this, of course, would be that you can run that graph and have the range work automatically for different sized data sets.. without having to mannually re edit the range. Jono "Jon Peltier" wrote: How are you defining the ranges? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "onzilla" wrote in message ... i had some dynamic ranges working for charts in excel 2003 - now I have 'upgraded' to 2007 and the dynamic range for charts don't work. (they work when in compatibility mode, but not when save as new 2007 xls). Any ideas? |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
dynamic ranges in excel 2007
Email me off-line. If it's a simple problem, I won't bother with all that.
jp at-sign peltiertech dot com - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "onzilla" wrote in message ... Jon, I am sorry to trouble you with this.. I figured out I was doing something else wrong. It is complex worksheet. How much do you charge for consulting per hour? "Jon Peltier" wrote: I can't reproduce your issue. I entered your exact formula as the refers-to formula for a range, then used the range in the series formula, and the series became dynamic, as expected. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "onzilla" wrote in message ... Range 'Refers To' =OFFSET($A$1,0,0,COUNT($A:$A),1) the purpose of this, of course, would be that you can run that graph and have the range work automatically for different sized data sets.. without having to mannually re edit the range. Jono "Jon Peltier" wrote: How are you defining the ranges? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "onzilla" wrote in message ... i had some dynamic ranges working for charts in excel 2003 - now I have 'upgraded' to 2007 and the dynamic range for charts don't work. (they work when in compatibility mode, but not when save as new 2007 xls). Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Dynamic names for chart series | Charts and Charting in Excel | |||
VIEWING adjacent/nonadjacent cells or cell ranges in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Beta-Named Ranges | Excel Discussion (Misc queries) | |||
Dynamic Ranges | Excel Discussion (Misc queries) | |||
Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions |