graph help!

[kclerk518]

need to know how to set my chart series to pull data from every other 6 cells from the same column. i have 6 series (heb, haz, dal, etc). i have a stacked bar graph (couldn't figure out how to upload a pic of it) and currently have to manually change each series value each week to update the graph with new data each week. help!!

Nov 27	HEB	338,294
	HAZ	309,003
	DAL	10
	CAN	15,868
	INTL	3,916
	MISC	10
Dec 04	HEB	166,974
	HAZ	308,097
	DAL	0
	CAN	16,535
	INTL	2,603
	MISC	85
Dec 11	HEB	248,227
	HAZ	178,325
	DAL	2,028
	CAN	17,950
	INTL	5,003
	MISC	6,203
Dec 18	HEB	330,135
	HAZ	161,798
	DAL	0
	CAN	68,916
	INTL	3,249
	MISC	72
Dec 25	HEB	14,389
	HAZ	44,115
	DAL	0
	CAN	345
	INTL	873
	MISC	1

<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[JumpingCrab]

You can add the date for each row (not just at the starting code of the day) and showall the data in a PivotChart.
That way you can manipulate the chart in any way you want. When you add ne data, you just have to refresh the chart.

Hope this gets you in a direction that could work.