Home |
Search |
Today's Posts |
#1
|
|||
|
|||
PivotChart Data Field - can it be value?
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
How do I change how PivotChart data is summarized, from sum to av. | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Word field codes in Excel data file Includetext | Excel Discussion (Misc queries) |