crazy chart task

  • Thread starter Thread starter quiettechblue
  • Start date Start date
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)?
 
(e-mail address removed) (e-mail address 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)?
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.
 
Back
Top