dynamic charts

[osfard]

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/Pub0009/LPMArticle.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

 

[Jon Peltier]

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

http://peltiertech.com/WordPress/2008/05/14/dynamic-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

 

[smartin]

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/Pub0009/LPMArticle.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?

 

[smartin]

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

http://peltiertech.com/WordPress/2008/05/14/dynamic-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

OT

Jon,

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

 

[Jon Peltier]

Excellent, I'll see you there.

- Jon