Radar chart reference line and totals in a pivot table
I am having trouble getting 1 reference line to show in the radar chart. Also, I cannot get totals to show up on the pivot table. I have been messing around with the properties for a while now but I can't seem to get anything to work. Any help is appreciated. Thanks in advance.
For totals in a pivot table, check "Show partial sums" for each dimension that you want to be summed up - it's in the Presentation tab of the Pivot Table.
For radar charts - also in Presentation tab, define your Reference line with any expression. Make sure that the number is whinin the range of the Axis and that the number is somewhat comparable to the chart values. The reference line appears as a circle on radar charts.
