# Dynamic Chart Failure

#### Puuuuma

##### New Member
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?

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

Anyone?

#### Puuuuma

##### New Member
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

Last edited:

#### Puuuuma

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

#### JustinWWolcott

##### Board Regular
how do you have your data set up?

#### Puuuuma

##### New Member
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.

Last edited:

#### JustinWWolcott

##### Board Regular
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)

Replies
3
Views
75
Replies
0
Views
513
Replies
6
Views
298
Replies
2
Views
224
Replies
0
Views
112

1,191,610
Messages
5,987,659
Members
440,104
Latest member
thigarette

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back