Dynamic Chart Failure

[Puuuuma]

1. I'm using Excel 2007
2. I'm trying to create a dynamic chart - following instructions from the numerous other threads on the topic
3. When I try to use a dynamic named range in the "Select Data Source" box, it creates a fatal error and the program shuts down. Any suggestions?

I like making things dynamic - please help!

 

[Puuuuma]

Anyone?

 

[Evagrius Ponticus]

can you paste your formula?

 

[Puuuuma]

DLbspHr =OFFSET(ByTime!$E$5,0,0,COUNTA(ByTime!$B:$B)-3,1)
ChartDate =OFFSET(ByTime!DLbspHr,0,-4)

The "SERIES" formula is not available in 2007, as far as I can tell, so in the SeriesYValues box in the Select Data Option I put DLbspHr and then when I try to save and close, excel closes. And ChartDate is used for the X axis

 

[Puuuuma]

Please and thank you?

 

[Puuuuma]

This is my last attempt to find a hero...are you it?

 

[JustinWWolcott]

how do you have your data set up?

 

[Puuuuma]

The Date is in column A, Weight Processed by the Day shift in column E, by night shift in column J. It all starts in row 5 and goes down (there are titles and running averages above that.

 

[JustinWWolcott]

this is how I'd set it up:


Ex_Axis = offset(ByTime!$a$5,0,0,COUNTA(ByTime!$B:$B)-3,1)


Values = offset(ex_axis,0,5,counta(ex_axis),1)

 

[Puuuuma]

Thanks Justin!! Your help really made a difference!