Dynamic Charting

I would like to have a dynamic chart so as I add data, the chart will be updated automatically.

The X axis would be the dates, the Y axis the amounts and the people as individual lines

I have attached a copy of the workbook

Thanks for the help

Lots of examples at http://www.contextures.com/JPChartIndex.htm

I am not familiar with Excel 2007 or Excel 2010 charting.

Can someone else help?

Paul:
I figured it out myself. I'll be glad to walk you through the steps:

You need three items
- OFFSET function
- Named range
- Function such as COUNT, or COUNTIF

- First, you need a COUNT function or COUNTIF function. Basically, it tells me how many rows or columns of data I have. This is the dynamic
portion of my data

- You need to defined a named range with an OFFSET formula. If you understand the OFFSET function, you are set. If not, read up on how this works.

- Now in Data Series portion of the graph, put in the named range

I am including a dynamic range example workbook. In this example:
- Cell F81 of worksheet 2013 uses a COUNT function to determine how many days of data I have.
- The Y data series uses a NAMED RANGE. In my example, =temp.xls!data_2013 where Data_2013 is the NAMED RANGE
- The NAMED RANGE Data_2013 has the OFFSET function. In my example, =OFFSET('2013'!$B$82,1,0,'2013'!$F$81,1)

As the data increases, the COUNT increases, which increases the data in the OFFSET function. Using the named range in the Data Series, makes the whole thing dynamic

Hope this is clear