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!!

[TABLE="width: 555"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Nov 27[/TD]
[TD]HEB[/TD]
[TD]338,294[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]HAZ[/TD]
[TD]309,003[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]DAL[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]CAN[/TD]
[TD]15,868[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]INTL[/TD]
[TD]3,916[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MISC[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Dec 04[/TD]
[TD]HEB[/TD]
[TD]166,974[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]HAZ[/TD]
[TD]308,097[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]DAL[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]CAN[/TD]
[TD]16,535[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]INTL[/TD]
[TD]2,603[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MISC[/TD]
[TD]85[/TD]
[/TR]
[TR]
[TD]Dec 11[/TD]
[TD]HEB[/TD]
[TD]248,227[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]HAZ[/TD]
[TD]178,325[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]DAL[/TD]
[TD]2,028[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]CAN[/TD]
[TD]17,950[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]INTL[/TD]
[TD]5,003[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MISC[/TD]
[TD]6,203[/TD]
[/TR]
[TR]
[TD]Dec 18[/TD]
[TD]HEB[/TD]
[TD]330,135[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]HAZ[/TD]
[TD]161,798[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]DAL[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]CAN[/TD]
[TD]68,916[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]INTL[/TD]
[TD]3,249[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MISC[/TD]
[TD]72[/TD]
[/TR]
[TR]
[TD]Dec 25[/TD]
[TD]HEB[/TD]
[TD]14,389[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]HAZ[/TD]
[TD]44,115[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]DAL[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]CAN[/TD]
[TD]345[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]INTL[/TD]
[TD]873[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MISC[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.