Blog Detail

da TaB is On

da TaB is On

http://databison.com

Excel Charts, Tips, Formulas and VBA. Learn useful excel tricks and tips. Download excel chart templates, dashboards, demos and VBA code.

subscribe Recent Posts

  • Why do Women Shop

    Posted on Monday November 9th, 2009 at 00:35 in fun

    Of all the mysteries in the world, one of the most profound is - why do women shop. A man can probably go through most of his adult career with a pair of conservatively stitched suits and matching ties. My old man still takes great pride in a dark, s...

  • OLAP Cube in Excel and Pivot Table From External Data

    Posted on Wednesday November 4th, 2009 at 23:51 in olap, pivot table

    OLAP Cubes provide a convenient way to crunch data in Excel. Imagine a Pivot Table pulling information from thousands or millions of data points with hundreds of columns and you being able to share this humongous data set with colleagues using an Exc...

  • Pivot Table Quick Tip - Group By Year, Quarter, Month and Date Field

    Posted on Monday November 2nd, 2009 at 00:19 in pivot table

    It’s monday morning and you’ve got a pivot table on your hands - its source data consisting of three columns – product, date and sales volume over a preiod of time. A pivot table created using this as underlying data may typically hav...

  • Halloween Special - 3 Wicked Things You Can Do with Excel

    Posted on Friday October 30th, 2009 at 01:27 in fun, excel fun

    I reckon that today would be the last working day before Halloween and it might be your only chance to get even. So here are a few Excel tricks especially for you this Halloween - each one getting progressively meaner. Send somebody a Workbook that j...

  • Scatter Chart with Highlight Box to Group Data Points in Chart

    Posted on Wednesday October 28th, 2009 at 14:20 in excel chart, scatter chart

    A scatter chart helps to plot data with two or more variables. One great advantage that a scatter chart has is the ability to show a relatively large number of data points in a small area. However, as the number of points plotted within the same spac...

  • Chart Label Trick - Using Interactive Labels on Chart

    Posted on Sunday October 25th, 2009 at 02:08 in excel chart, chart label

    In Applying Offset Labels to Chart we looked at how a chart’s labels can be offset to avoid cluttering. But what if you wanted to use the chart to narrate a story - and a pretty long one at that? How would you do it? If you turn on the chart ax...

Comments & Reviews

This blog is currently rated a 5.00 out of a possible 5 based on 1 comment.

JP2112

5 stars Jimmy Pena

Great Excel blog, lots of useful tips.

Posted: October 20th, 2009 | More Reviews From JP2112 | Report This Comment

Post A Comment/Review

* Your IP is being logged.
* Your e-mail address is used only for verification purposes only and will not be sold, or shown publicly.
* No HTML tags allowed
* DO NOT use the Comments/Reviews to promote your own site.

Name: or Login
E-mail:
Rating:
Verify: Spam Protection: sum of 3 + 1
Comment:
  Remember Information