Excel
What's New Blog - Go Back to Previous Locations Pivot - Sort With Custom List
Excel Tips, Excel Tutorials and Excel Techniques
Jon Peltier's Web Site -- Excel Chart Index
Filled Histograms Using Excel XY-Area Charts
I recently showed how to create Histograms Using Excel XY Charts . This technique produces a human-friendly numerical X axis scale, which is easier to read and harder to be deceived by than the bin labels used by column chart histograms. The drawback of that technique is that it produces histogram bars in outline only, without a fill color. In this post I will show how to extend that technique to fill the bars, using the protocol from Fill Below an XY Chart Series with an XY-Area Combination Chart .
I recently showed how to create Histograms Using Excel XY Charts . This technique produces a human-friendly numerical X axis scale, which is easier to read and harder to be deceived by than the bin labels used by column chart histograms. The drawback of that technique is that it produces histogram bars in outline only, without a fill color. In this post I will show how to extend that technique to fill the bars, using the protocol from Fill Below an XY Chart Series with an XY-Area Combination Chart .
The Excel Charts Blog — Charts, Dashboards and Effective Data Visualization for Excel Users
Data Visualization for Excel Users Welcome to the place where you can learn best practices for effective Excel charts in a corporate environment. In other words, where Tufte meets Excel .
With a running total in a pivot table, you can see how amounts accumulate over a period of time, or through a range of products. To create a running total, use the Custom Calculation feature in a pivot table. In this pivot table tutorial, we'll focus on the Running Total custom calculation.
Excel Pivot Table Tutorial -- Running Totals