Hello,
I have some charts I previously created using a pivot table. I have averages (2) calculated on this pivot table, that show up as columns on my chart (2 averages for each section). For example, Section A has 2 columns, Section B, 2 columns, Section C, 2 columns and so on. Now I have added a count formula to the pivot table, but that also shows up as a column for each Section. Is there any way to have the count show up for each section WITHOUT having it show up as a column. Maybe just a number. I will try and add a sample chart so it is a bit clearer about what I'm trying to do.
Start Free Trial