Chart Label Trick : Applying Descriptive Labels to Chart Series

Posted on 12 September 2009

Chart labels provide information related to the underlying data. In Excel, by default, chart labels can only consist of the following three - Series Name, Category Name and Chart X & Y Values. So what about situations when you want to convey additional information - for example, say a short description about the chain of events that had a material impact on sales (or say when you ... Continue Reading

Comments (8)

Pivot Table VBA: VBA to Read & Modify a Pivot Table in Excel

Posted on 11 September 2009

Here is a collection of VBA codes to work with Pivot Tables: 1. Create a pivot table using a VBA Macro 2. Delete all Pivot Tables Using a VBA Macro 3. Refer to a Pivot Table directly within a VBA Macro 4. Refer to a Pivot Table Field directly within a VBA Macro 5. Refer to a Pivot Item of a Pivot Field present in a Pivot Table directly using a VBA Macro 6. Remove old (ghost) Items from ... Continue Reading

Comments (1)

Calculated field and Calculated Items in a Pivot Table

Posted on 11 September 2009

Calculated field and Calculated Items of a pivot table get their values from the result of a formula. Calculated Field A calculated field allows the user to insert a new data field into the pivot table – one which does not exist in the base data but gets its value from a formula. The formula in turn can include existing fields, numbers and other arithmetical operators. Let’s understand this a little better. Whenever you create a pivot table, by default, the list ... Continue Reading

Comments (1)

Custom Format in Excel - How to Format Date and Time

Posted on 07 September 2009

In custom format in Excel we discussed using the custom format feature to format text and numbers. In this article, we format date and time values and see how we can make them appear more meaningful. If you haven't had a chance to read through the first part where we talked about basics of the custom format feature, it is highly recommended that you do so before coming back and finishing this one off. Before we begin, again please bear ... Continue Reading

Comments (2)

Bar Chart with an Average Line for Each Group in Chart

Posted on 04 September 2009

In our previous article we covered adding an average line to a bar chart. At times, however, it may be useful to show an average line for each period or group when the chart consists of more than one such period or group. The advantage here is apparent - not only can the reader view the data points individually, he/she is also able to build a map of how various groups are placed with in relation to each other.... Continue Reading

Comments     

Interactive Chart in VBA using Mouse Move Event

Posted on 02 September 2009

VBA can be used to make interactive charts that respond to mouse movements. In this article we first start of by making a simple bar chart embedded in a chart sheet and then use the mouse move event of the chart sheet to make it interactive. Create a simple Bar Chart For the purpose of this exercise, we take the list of top 15 billionaires and sort it based on their networth. We ... Continue Reading

Comments (4)