Conditional chart series.

[Guest]

If I have a table of data which has Date as column 1, Department as column 2
as Sales data in Column 3. (For example...)

A B C
01/01/07 Dept 1 10
01/01/07 Dept 2 20
01/01/07 Dept 3 30
02/01/07 Dept 1 40
02/01/07 Dept 2 50
02/01/07 Dept 3 60

....

It doesn't have column headers as it stands.

What I would like to do is have a chart with the Date (Column 1) as the 'X'
axis, and 3 series, one for each Department (Column 2), against a 'Y' axis as
determined by the number of Sales (Column 3).

I'm using Excel 2003, but short of a Pivot chart I don't know how to do this.

Further info, the reason I'm trying to use an ordinary chart is that I
actually have more than 3 columns. as I have other data in my table which I
would also like to chart, however I'm writing code to determine the data
source for the series and doing this on a Pivot Chart I feel would be more
difficult.

I could refresh the pivot table data, then copy this out into a static data
table where I have the Dept as column headers, but this seems a bit
ineffecient to me and was hoping that I could do this another way.

Any help would be great.

TIA.

 

[Jon Peltier]

Several options:

Pivot table plus regular chart
(http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=553)
Conditional chart, requires additional columns
(http://peltiertech.com/Excel/Charts/ConditionalChart1.html)

- Jon