Grouping\graphing Data

I am having a problem at the moment as i have some data that is in groups but the groups get bigger or smaller all the time. How can i graph these so that it includes any extra rows in the graph? Usually i would just highlight a load of extra blank rows to cover this but there are different groups below them that are not included in the graph.

The short version is i want to know how to graph grouped data.

Thanks

You may use dynamic named ranges. There are some examples of that here:
http://www.ozgrid.com/Excel/DynamicRanges.htm
There is not an exact example of what you need, but it may give you some
ideas.

Hope this helps,
Miguel.

"mintys247" wrote:

>
> I am having a problem at the moment as i have some data that is in
> groups but the groups get bigger or smaller all the time. How can i
> graph these so that it includes any extra rows in the graph? Usually i
> would just highlight a load of extra blank rows to cover this but there
> are different groups below them that are not included in the graph.
>
> The short version is i want to know how to graph grouped data.
>
> Thanks
>
>
> --
> mintys247
> ------------------------------------------------------------------------
> mintys247's Profile: http://www.excelforum.com/member.php...o&userid=35167
> View this thread: http://www.excelforum.com/showthread...hreadid=553072
>
>