Tell me more ×
Cross Validated is a question and answer site for statisticians, data analysts, data miners and data visualization experts. It's 100% free, no registration required.

I have a panel chart composed of 4 panels, each with 12 bars that essentially show data from a pivot table. The default layout has the first 11 rows show individual points, with the 12th row showing a total of the entire column. Similarly, the final column shows a total of the 3 preceding columns. The result is the total for all values is bottom right, like in pivot table.

My question is whether there's a benefit or preferred method to rearranging the panels and data points so that the aggregate data is top left in the chart, making it the first value seen (in traditional left-right, top-bottom reading), or keeping the more traditional mathematic approach with totals at the bottom and to the right? Thanks for your help.

share|improve this question

1 Answer

up vote 1 down vote accepted

After a great deal of experimenting and googling (to no avail), I've decided for a quasi-dashboard application (which this is), that having the aggregate column at left and row at top makes the most sense for my users. It's taking me-and my pivot table experience-a while to get used to it, but left-right, top-bottom organization seems to make the most sense for my other users. Still open to anyone elses comments.

share|improve this answer
It's not the best reasoned answer (and I have nothing substantive to back it up), but it's working for now. If anyone has a better one, please let me know and I'm happy to open it back up. – David Vandenbos May 14 '12 at 16:41

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.