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@yahoo.com - 19 Mar 2008 04:04 GMT
quiettechblue@yahoo.com quiettechblue@yahoo.com left this in
microsoft.public.excel:
> excel 2003 on XP
> We are tracking some workload variables.
[quoted text clipped - 11 lines]
> 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.