I am using Excel 2003 and my pivot chart is working fine. I have multiple
data points in the data field. My problem is I would like it to chart all of
the points, not the average like I am currently using. The pivot table is
setup on a line chart currently. Thank you for your help in advance, I know
that there is a simple answer but I am missing it some where.

Tim

Hi,

Pivot charts plot what Pivot tables display. So the problem is not in your
chart but in the pivot table. You must set it up so it display all your
point. We don't have enough info to tell you have to do it.

If this helps, please click the Yes button

cheers,
Shane Devenshire

"tpeter" wrote:

I am using Excel 2003 and my pivot chart is working fine. I have multiple
data points in the data field. My problem is I would like it to chart all of
the points, not the average like I am currently using. The pivot table is
setup on a line chart currently. Thank you for your help in advance, I know
that there is a simple answer but I am missing it some where.

Tim

Thanks Shane,

Here is an example of the data that I am using:

Date Time Flow Outlet Max Min Time
10/1/2007 12:02 AM 25 55.381989 60.959839 52.617996 36346.66797
10/1/2007 12:14 AM 50 53.924217 59.198936 52.643921 36346.87891
10/1/2007 12:26 AM 75 53.734764 58.738274 52.81144 36347.02344
10/1/2007 12:38 AM 100 53.832481 59.280701 52.769562 36347.23438
10/1/2007 12:49 AM 150 53.411697 59.037407 52.703751 36347.44922
10/1/2007 1:01 AM 200 53.533348 58.698387 52.596062 36347.66406
10/1/2007 1:13 AM 250 53.778641 58.67247 52.841354 36347.875
10/1/2007 1:25 AM 0 56.97139 58.895813 52.81144 36348.01953
10/1/2007 1:37 AM 25 53.451584 60.931923 52.739647 36348.23047
10/1/2007 1:48 AM 50 53.517395 59.308624 52.384674 36348.44531
10/1/2007 2:00 AM 75 55.723003 58.71434 52.731667 36348.65625
10/1/2007 2:12 AM 100 53.599152 58.722321 52.723694 36348.80078
10/1/2007 2:24 AM 150 53.613121 58.628593 52.580109 36349.01172
10/1/2007 2:35 AM 200 53.3778 58.642555 52.69976 36349.22656
10/1/2007 2:47 AM 250 53.485481 59.023453 52.69976 36349.44141
10/1/2007 2:59 AM 0 57.392174 58.590706 52.424561 36349.58203
10/1/2007 3:11 AM 25 53.274101 60.882065 52.616005 36349.79688
10/1/2007 3:23 AM 50 53.463554 58.596687 52.621986 36350.00781
10/1/2007 3:34 AM 75 53.66098 58.680443 52.576118 36350.22266

The date range is for10-1-07 to 11-17-08 and there are 11,500 records. The
pivot table only has about 50 points (assuming that it is averaging all of
the point from each date). Please let me know if you have any questions. I am
plotting flow(x-axis) vs outlet(y-axis).

Tim


"Shane Devenshire" wrote:

Hi,

Pivot charts plot what Pivot tables display. So the problem is not in your
chart but in the pivot table. You must set it up so it display all your
point. We don't have enough info to tell you have to do it.

If this helps, please click the Yes button

cheers,
Shane Devenshire

"tpeter" wrote:

I am using Excel 2003 and my pivot chart is working fine. I have multiple
data points in the data field. My problem is I would like it to chart all of
the points, not the average like I am currently using. The pivot table is
setup on a line chart currently. Thank you for your help in advance, I know
that there is a simple answer but I am missing it some where.

Tim