crazy chart task

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)?

quiettechblue
Tue Mar 18 22:04:16 CDT 2008

quiettechblue@yahoo.com quiettechblue@yahoo.com 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.