Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

crazy chart task

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
quiettechblue@yahoo.com - 15 Mar 2008 19:22 GMT
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.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.