Excel Formula, Excel Chart, Excel Macro, Excel VBA, Pivot Table Excel, Excel Dashboard

Using Custom Format to Color Chart Axis and Chart Labels

Custom Format can be used to format numbers, text, dates and time. The technique can be extended to charts as well where the custom format feature can be used to color the chart axis and chart labels. In this example, let's say we wanted to show the sales numbers for a particular duration as a chart. We would, in addition, like to have some kind of separation between what is considered below, average and ...

Chart Label Trick : Applying Offset Labels to Excel Chart Series

Posted on 24 September 2009

In Chart Label Trick - Descriptive Labels we talked about adding custom labels to chart. In this article we discuss offsetting chart labels - which means positioning the labels above or below the actual data points at a predetermined distance. Getting the chart data in place Like always, we first get the chart data in place. For the purpose of this chart, we will use two data series - the first ...

Comments (4)

HTML to Excel using Javascript and Excel to HTML using VBA

Posted on 23 September 2009

This two part article consists of: Part A - Converting HTML to Excel using Javascript Part B - Exporting Excel to HTML using VBA HTML to Excel using javascript Let’s first take a look at tables in html. Data tables are typically stored in HTML using the <table> tag. Such a table will typically consist of one or more rows (<tr> tag) with each row having one or more cells (<td> tag). To read a table from an HTML document ...

Comments

VBA Code - Multiple Column Text to Column Conversion

Posted on 21 September 2009

Here's a bit of VBA code to convert Text to Column which will work across multiple columns selected together at one go. ...

Comments

Chart Label Trick - Converting Chart Axis Labels to Table

Posted on 18 September 2009

The labels used with the chart category axis are probably the most ignored part of the entire chart making process. You see, the labels on the value axis can be modified, the bars, the lines and the plot area - all of them can be embellished - colors added, widths adjusted, descriptions applied - the works you know ! Even the poor little gridlines can afford a makeover. But what about the chart's category axis label - what do ...

Comments (2)

Conditional Formatting and Custom Format - Use More than Three Colors

Posted on 16 September 2009

Conditional formatting (in pre Excel 2007 versions) had a limitation of only allowing for upto three conditions for formatting cells. A quick way to include more than three conditions when using conditional formatting is to use the custom format feature in tandem with it. Conditional formatting can be used to specify the first three conditions and then upto three additional conditions can be specified using custom format - giving us 6 different colors to work with. ...

Comments (1)

Chart Table - When Chart meets Table

Posted on 15 September 2009

Chart table - as the name suggests - is a beautiful fusion of a chart and a table giving rise to a visually appealing yet information rich presentation of data. Not that the concept itself is anything new - experts have openly and vociferously championed the cause of the chart table, its various facets have been discussed at length in numerous forums and the latest versions of excel come equipped with tools that further aid their creation (namely sparklines). However ...

Comments (5)