| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Chart
When importing data to a Pivot Table chart (by dragging it) the field setting
default is COUNT. Can I change this default to AVERAGE or SUM? -- Ken Knight |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Chart
Excel will use Sum if all the data in that field/column is numeric. If there's
anything else (text or even an empty cell), excel will show count. I don't think you can change this behavior. Ken Knight wrote: When importing data to a Pivot Table chart (by dragging it) the field setting default is COUNT. Can I change this default to AVERAGE or SUM? -- Ken Knight -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Chart
Thanks for the information. However, I want the default behaviour to be SUM
or AVERAGE, but I'm getting COUNT, even though all the data I'm dragging is numeric (the result of a calculation on another worksheet in the workbook, linked by Paste Link). Any other ideas most welcome! Ken -- Ken Knight "Dave Peterson" wrote: Excel will use Sum if all the data in that field/column is numeric. If there's anything else (text or even an empty cell), excel will show count. I don't think you can change this behavior. Ken Knight wrote: When importing data to a Pivot Table chart (by dragging it) the field setting default is COUNT. Can I change this default to AVERAGE or SUM? -- Ken Knight -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Chart
You have at least one empty/blank/non-numeric cell in that field, else you would
have seen Sum. (Maybe the range includes an extra row at the bottom???) And when you find a way to change this behavior, please post back. Ken Knight wrote: Thanks for the information. However, I want the default behaviour to be SUM or AVERAGE, but I'm getting COUNT, even though all the data I'm dragging is numeric (the result of a calculation on another worksheet in the workbook, linked by Paste Link). Any other ideas most welcome! Ken -- Ken Knight "Dave Peterson" wrote: Excel will use Sum if all the data in that field/column is numeric. If there's anything else (text or even an empty cell), excel will show count. I don't think you can change this behavior. Ken Knight wrote: When importing data to a Pivot Table chart (by dragging it) the field setting default is COUNT. Can I change this default to AVERAGE or SUM? -- Ken Knight -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
| Pivot table chart - turn off automatic color | Charts and Charting in Excel | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Change Data In Pivot Table | New Users to Excel | |||
| How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta. | Excel Discussion (Misc queries) | |||
Linear Mode
