crazy chart task

Q

quiettechblue

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

quiettechblue

[email protected] [email protected] 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)?
Click to expand...

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