LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Steve
 
Posts: n/a
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exclude pivot table data from pivot chart? coal_miner Charts and Charting in Excel 4 April 17th 07 07:11 AM
Pivot chart issue James Charts and Charting in Excel 8 September 13th 05 12:35 PM
How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta. Jersey Girl Excel Discussion (Misc queries) 1 March 10th 05 04:20 AM
pivot chart format Valeria Charts and Charting in Excel 1 January 14th 05 01:19 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"