[Sigia-l] Search log analysis reporting - Excel help?

[Anjali Arora]

Related to this discussion, I'd like to learn more about Excel's graphing /
visualization capabilities. What I am trying to do is to depict a
visualization of files in a system along various parameters. I've been
thinking along the lines XML file into Flash to demo my ideas, but would
love to learn more about what Excel can do. Any good starting points to play
around with?

Thanks!
-Anjali

----- Original Message -----
From: "Billie Mandel" <Billie.Mandel at openwave.com>
To: "SIGIA-L" <sigia-l at asis.org>
Sent: Friday, October 21, 2005 7:24 PM
Subject: RE: [Sigia-l] Search log analysis reporting - Excel help?


> Yeah, yeah - I figured *someone* would decide I was probably overlooking
something (should have guessed it would be another New Yorker ;-) )
>
> You're right - this should be easy.  It's totally easy to create a stacked
chart in Excel.  My problem is that the values I need to chart aren't
consistent across columns.  Say my first stack is titled Email, and it has
Outlook, Exchange and Webmail in it.  My second stack is titled Vacation,
and I want the blocks within it to be Time Off, Holidays, Leave of Absence
and Maternity, but Excel can only use the values from the first column -
essentially, one legend per graph.  All Excel will give me is a second
column called Vacation, but which is also comprised of Outlook, Exchange and
Webmail.
>