Hi,

I've got a pivot chart which has X = Total Sales, Y = Product Code, and Data
Series = Year&Month; from a pivot table which has Rows = Product Code,
Columns = Year&Month, and Data = Total Sales. This graph isn't particularly
usefull to my sales guys as it doesn't really show how a product has been
bough over a period of time, more of a colourful mess however the table is.

What I really want is to have X = Total Sales, Y = Year&Month, and Data
Series = Product Code. This should display a graph which will show what the
sales guys are after. However when I move the pivot fields to create this
graph it also changes the pivot table. Unfortunatly there are more than 250
product items so excel can't deal with this. Is there any way in which it
possible to select wheather columns or rows are the data set as aposed to
moving the pivot fields?

Thanks in advance

Graham

--
It's got to be going home time, at least going to the pub time