chart label | Excel & VBA

Multiple Scale Chart – Adding Customized Scale to Each Category in a Chart

So how do you fit multiple scales on a single excel chart? No, we are not referring about the primary and secondary scales on an Excel chart here, we are talking about adding a customized scale for each category in the chart. Take for example the receipts portion of the U.S. federal budget - a data set with multiple categories such as individual income, social security, excise, estate and other taxes & duties. ...

Chart Label Trick – Using Interactive Labels on Chart

Posted on 25 October 2009

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 axis labels, the entire thing gets messed up. Roots growing out of the chart axis wasn't exactly the point that we would like to highlight to someone who's ...

Comments (4)

Chart Label Trick – Label Last Point in a Line Chart and Offset Axis Crossover

Posted on 07 October 2009

Kaiser (Junkcharts) posted this line chart sometime back. A recreated chart is shown below where labels have been added to last point of each series in the chart. If you noticed, the labels have also been enhanced to show both the series name and the value of the data point. Lastly, the Y Axis of the chart has been offsetted to crossover at the last category. The benefits are obvious - the ...

Comments (1)

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 (8)

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 (3)

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 ...

Comments (13)