S
Steve
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
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