<div>
Great - Thanks for your help
</div>


<div>
<div class="content wysiwyg-content">
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...<br />
<br />
In reading up on charts, I see how to generate basic charts from simple tables<br />
In the example I was provided, the charts were based off of pivot tables<br />
And then I see there are such things as pivot charts. <br />
<br />
Can somebody explain (or point me to an article that explains) when you would chose one method over the others?<br />
<br />
Thanks
</div>
</div>


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?

Thanks

Excel charts, pivot charts, charts from pivot tables - which to use?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.