Posted on 03 July 2009
How to choose a chart? Which chart would best fit the data set that I have? How do I choose the better chart type from Excel? Finding the right type of chart for the data set that you have can be a bit of a challenge. Given a set of seemingly equivalent alternatives, picking one chart over the other can turn out to be quite an interesting exercise.
The chart chooser diagram can help you make a choice in situations ...
Continue Reading
Posted on 01 July 2009
The For Loop is one of the most frequently used loops in VBA. The For loop has two forms in VBA - For Next and For Each In Next. The For loop is typically used to move sequentially through a list of items or numbers. To end the for loop at any given point we can use the exit for statement. Let's take a closer look at each of these ...
Continue Reading
Posted on 29 June 2009
Chartjunk, a term first coined by Edward Tufte, refers to all those elements in a chart that add no further value. Chartjunk comes in many shapes and size - redundant labels, unnecessary gridlines, over-the-top use of colors and everything that a 'creative' mind can think of. However what should be kept in mind is that this term also has a strong contextual meaning. An element that may appear as chartjunk in one graph may serve a useful function in another ...
Continue Reading
Posted on 28 June 2009
How to create a pivot table using VBA? Assuming that the data for the pivot table is laid out like this, then all you need to
create a pivot using vba are there four lines of code:
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= ActiveSheet.UsedRange).CreatePivotTable TableDestination:="", TableName:= "PivotTable1", DefaultVersion:=xlPivotTableVersion10
ActiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(1, 1)
ActiveSheet.PivotTables("PivotTable1").AddFields RowFields:="Name"
ActiveSheet.PivotTables("PivotTable1").PivotFields("Name").Orientation = xlDataField
The pivot table so created using the VBA code above can be ...
Continue Reading
Posted on 28 June 2009
What was meant to be a leisurely stroll with my more-expensive half along the beachfront yesterday, turned into half an hour of soaking in the rain followed by about 2 hours of journey back home.
While on the way back, I saw a man helping a blind old woman onto the train carriage. A few minutes into the journey, as the station approached, she began walking towards the exit door. Fearing that she could miss her step and hurt herself, I ...
Continue Reading
