excel 2003 on XP
We are tracking some workload variables.

We have date, some classification and tracking information, some values
to track, and some descriptive and comment data.

I want to make a chart showing the tracking values by calendar week.

I almost have the week function working with match() and index().

I am having no luck at all getting the right information to the chart (a
clustered column chart). I used to know how to set up x and y axis
data, but the new "whizzard" tools defeat me at every turn. Could i
just use a manual chart (do they still exist)?

(E-Mail Removed) (E-Mail Removed) left this in
microsoft.public.excel:

> excel 2003 on XP
> We are tracking some workload variables.
>
> We have date, some classification and tracking information, some
> values to track, and some descriptive and comment data.
>
> I want to make a chart showing the tracking values by calendar week.
>
> I almost have the week function working with match() and index().
>
> I am having no luck at all getting the right information to the chart
> (a
> clustered column chart). I used to know how to set up x and y axis
> data, but the new "whizzard" tools defeat me at every turn. Could i
> just use a manual chart (do they still exist)?

Well i have worked through most of that, but my automatic formulas
produce some incorrect data. You should see some of my functions, i am
up to 5 and 6 levels now. Got my daily information chart up as well.
I am doing the dirty work on sheet2 now. Leaves a much cleaner sheet1.