Grouping\graphing Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mintys247 - 18 Jun 2006 21:45 GMT

I am having a problem at the moment as i have some data that is i
groups but the groups get bigger or smaller all the time. How can
graph these so that it includes any extra rows in the graph? Usually
would just highlight a load of extra blank rows to cover this but ther
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:

Reply to this Message

Miguel Zapico - 19 Jun 2006 03:41 GMT

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.

> 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
[quoted text clipped - 5 lines]
>
> Thanks:)

Reply to this Message