dynamic chart needs one last adjustment

[Hlatigo]

I have a dynamic chart that uses a defined name and the defined name has a formula that uses offset and count to update the chart when data appears. In order for it to work I have one table with 2 columns. The data range is A169:B177 and I want the titles on the left to show as the legend. where right now...i am only getting sales and products as the legend. thanks for your help

Named Total
=OFFSET('Net Exposure Calculation'!$B$169:$B$177,0,0,COUNTA('Net Exposure Calculation'!$B$169:$B$177)-1)

BASIS_SPREAD.xls
	A	B	C	D
169	Products	Total
170	FUEL	(56,352)
171	GASOILGR	268,783
172	GASOLINE	19,300
173	Flop	20,000
174
175
176
177
Net Exposure Calculation

 

[GlennUK]

The legend shows one key per series, and it sounds like that's what it's doing. What are you expecting exactly?

 

[Jon Peltier]

You need to define one name for the labels and one for the values. Create the chart using the name defining the products as the X values and the name defining the sales as the Y. This gives you one series, with one legend entry. Now format the series, and check the Vary Colors by Point box (Excel 2003: Format Series dialog, Options tab; Excel 2007, you're on your own).