' Clean up and delete old pivotTable and pivotChart ' arrColumn: array field, contains info about the column field ' arrRow: array field, contains info about the row field ' arrData: array field contains four infos about every field ' strTblNme: future name of the pivot-table ' This macro creates a pivot-table and a pivot chart based on the data in rPivot.
#INCLUDE STANDARD DEVIATION IN EXCEL GRAPH HOW TO#
but I dunno how to make the standard deviation (sample) appear as the y-error in my chart.Ĭode Sub addPivotTable(wks As Worksheet, rPivot As Range, strTblNme As String, arrData As Variant, arrRow As Variant, arrColumn As Variant, strNFormat) But it does not contain the standard deviation (sample), whereas this is exactly what I can calculate in the table. I know, there is the button to add a "y-error" where you can choose from. but for the pivot-chart, I don't know how to do so, cause relying on defined data-ranges for the chart, would not be a good idea in case somebody simply rearranges the pivot-chart, I fear.īelow you find the code, I have been able to make up so far, I appreciate any help,
But I cannot get the chart to show the "Standard Deviation" as a y-error of the "average"-values! (Also, but this is less important, I neither get to show the "amount of data" ON the correspondent column.) For a usual chart, I do know how to add the y-error.
#INCLUDE STANDARD DEVIATION IN EXCEL GRAPH CODE#
Reached so far: What I have been able to encode is the establishment of the pivot-table and the chart (see code below). I don't think that is something new or unusual, but I simply haven't found out, how to do so at all (in VBA). I would like to have the pivot-chart show a xlColumnClustered Chart with the "average" and the "Standard Deviation" ( as y-errors of the average!!!) - and if possible the "amount of data-sets" in/on/next to the correspondent column. My problem: In particular, I have a pivot-table with all "amount of data-sets", "average" and "Standard Deviation" of my data, which I'd like to visualise in a pivot-chart. But I am still having problems with its pivot-charts, especially in VBA.
I've just discovered how extraordinarily usefull pivot-tables can be.
0 kommentar(er)
