Hello,

I am trying to make a dynamic chart which would only plot a specified
range. I found a great example (please take a look for the specifics)

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

My only difference is that my date range goes across and not down. I
am having a difficult time defining the name "ChartDates" (I am using
the offset function incorrectly).

Please help :)

thanks in advance, O

In this blog post I show somewhat simpler examples of dynamic ranges:

http://peltiertech.com/WordPress/200...ynamic-charts/

Most of the examples are with data in columns, which generally is a better
choice. But I do have a section with Data in Rows, which should help with
the Offset syntax.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


wrote in message
...
Hello,

I am trying to make a dynamic chart which would only plot a specified
range. I found a great example (please take a look for the specifics)

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

My only difference is that my date range goes across and not down. I
am having a difficult time defining the name "ChartDates" (I am using
the offset function incorrectly).

Please help :)

thanks in advance, O

wrote:
Hello,

I am trying to make a dynamic chart which would only plot a specified
range. I found a great example (please take a look for the specifics)

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

My only difference is that my date range goes across and not down. I
am having a difficult time defining the name "ChartDates" (I am using
the offset function incorrectly).

Please help :)

thanks in advance, O

Hello,

Take a look at how the OFFSET function works. The 2nd and 3rd parameters
are for row and column offsets, respectively. The site assumes data in
rows, not columns, so you need to transpose the sense of the references
for your application.

Working backward from the site's example, you will need to look at how
the MATCH function is set up. Make sure the named range applies to a
row, not a column.

Does this help?

Jon Peltier wrote:
In this blog post I show somewhat simpler examples of dynamic ranges:

http://peltiertech.com/WordPress/200...ynamic-charts/

Most of the examples are with data in columns, which generally is a better
choice. But I do have a section with Data in Rows, which should help with
the Offset syntax.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com

OT

Jon,

I will be attending the "Excel Dashboard and Visualization Boot Camp" in
October. I look forward to meeting you and all attendees!

Excellent, I'll see you there.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"smartin" wrote in message
...
Jon Peltier wrote:
In this blog post I show somewhat simpler examples of dynamic ranges:

http://peltiertech.com/WordPress/200...ynamic-charts/

Most of the examples are with data in columns, which generally is a
better choice. But I do have a section with Data in Rows, which should
help with the Offset syntax.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com

OT

Jon,

I will be attending the "Excel Dashboard and Visualization Boot Camp" in
October. I look forward to meeting you and all attendees!