Pivot Chart HELP
 

I am trying to create an area chart but I know I'm doing something wrong.
What I want is a chart that will plot the intersection of two numbers and
show a label (happens to be a date).

Both axis go for zero to 1. I have a query table that shows:
Category# Item# Date Pf# Cf#
1 1 6/30/05 0.5 0.65
1 2 9/30/06 0.8 0.8
1 3 7/15/06 0.7 0.7
2 1 4/1/05 0.4 0.4
2 2 5/3/06 0.2 0.25
3 1 ETC......

When I place the Cf# or Pf# in any of the pivot chart areas and click open
the little down arrow all I see is the All check box and only a 0.00 check
box. None of the values show up. The other fields show there data.

The books and help file don't seem to help, mostly because I don't know how
to state the question properly.

Thanks, Steve

Sorry, I should have said XY (Scatter) chart, not area chart.

Steve
"Steve" wrote in message
...
I am trying to create an area chart but I know I'm doing something wrong.
What I want is a chart that will plot the intersection of two numbers and
show a label (happens to be a date).

Both axis go for zero to 1. I have a query table that shows:
Category# Item# Date Pf# Cf#
1 1 6/30/05 0.5 0.65
1 2 9/30/06 0.8 0.8
1 3 7/15/06 0.7 0.7
2 1 4/1/05 0.4 0.4
2 2 5/3/06 0.2 0.25
3 1 ETC......

When I place the Cf# or Pf# in any of the pivot chart areas and click open
the little down arrow all I see is the All check box and only a 0.00 check
box. None of the values show up. The other fields show there data.

The books and help file don't seem to help, mostly because I don't know
how
to state the question properly.

Thanks, Steve