ExcelBanter - PivotChart Data Field

Even though the data is in a pivot table, you can still make a real chart out of it.
Start by selecting a blank cell away from the pivot table, choose XY Scatter in the
first step, and use the Series tab to add the series one at a time. It's not too
tedious. Unfortunately it doesn't automatically update when the PT updates, which is
why Bill Gates invented VBA.

To show each value, not the sum/average, add a dummy column with different values. I
uses =ROW() in this table, and =RAND() for the values:

Var A Var 1 Value Dummy
A 1 0.792251876 2
A 1 0.917002952 3
A 2 0.097322931 4
A 2 0.019832247 5
B 1 0.98382827 6
B 1 0.388763063 7
B 2 0.253372723 8
B 2 0.584837141 9

The extra column turns this table:

Sum of Value
Var A Var 1 Total
A 1 1.404625155
2 1.319569005
B 1 1.039707625
2 0.824970186

into this:

Sum of Value
Var A Var 1 Dummy Total
A 1 2 0.996150814
3 0.40847434
2 4 0.837824093
5 0.481744912
B 1 6 0.428103073
7 0.611604553
2 8 0.779638937
9 0.045331248

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

pajordan wrote:

I have a data set of nodes that generated error codes at different times. I
want to plot the data with a separate series for each error code, with time
on the x-axis and node on the y-axis. I want to use a PivotChart so I can
select to show only certain error codes or nodes of interest. I am having
trouble setting up the PivotChart (Excel2000). I can't do it as a scatter
plot (not allowed for PivotCharts), so I chose Line with Markers. The
problem is the data field - the available options are like Sum, Count,
Average, etc. but I want it to be Value, as in the value of the node.
(Better to see a picture of it:
http://photobucket.com/albums/y17/pa...questio n.jpg
hope that works)
Am I going about this the wrong way? Any advice? Thanks.