Excel charts, pivot charts, charts from pivot tables - which to use?
Posted on 2014-01-23
Hello - I'm an Access developer that has been asked to spiff up a spreadsheet that holds employee rewards. It has the expected data: division, department, # of recipients in a given reward, reward area, reward type, etc...
In reading up on charts, I see how to generate basic charts from simple tables
In the example I was provided, the charts were based off of pivot tables
And then I see there are such things as pivot charts.
Can somebody explain (or point me to an article that explains) when you would chose one method over the others?