Excel Tips and Techniques

How to use a macro to add labels to data points in an xy scatter chart or in a bubble chart in Excel In Microsoft Excel, there is no built-in command that automatically attaches text labels to data points in an xy (scatter) or Bubble chart. However, you can create a Microsoft Visual Basic for Applications macro that does this. This article contains a sample macro that performs this task on an XY Scatter chart. However, the same code can be used for a Bubble Chart. Microsoft provides programming examples for illustration only, without warranty either expressed or implied. To use the macros in this article, create a chart using the following data: A1: Labels B1: X Values C1: Y Values A2: DataPoint1 B2: 12 C2: 5 A3: DataPoint2 B3: 9 C3: 7 A4: DataPoint3 B4: 5 C4: 3 A5: DataPoint4 B5: 4 C5: 8 A6: DataPoint5 B6: 1 C6: 4 NOTE: The table should not contain empty columns, and the column that contains the data labels should not be separated from the column that contains the x values. To attach text labels to data points in an xy (scatter) chart, follow these steps:

Vertex42 - Excel Templates, Calendars, Calculators and Spreadsheets ExcelRibbon.Tips.Net - Powerful tips on using Microsoft Excel Toodledo : A to-do list to organize your tasks Appwikia - Best Windows and Android Apps for You Fun With Dummy Series Introduction Microsoft Excel offers many chart types and many chart effects, but sooner or later you'll want to do something that Excel doesn't offer. Many effects can be accomplished through the use of extra series and clever formatting. For example, you might want a customized axis style, or a line or shape drawn in a particular position, or text labels that are tied into axis values. Several of these tricks with dummy series are adaptations of 's and techniques, from his web site, . While custom labeling of dummy series points can be done manually, most of these tricks rely on 's , a free add-in available for download at , or 's , another free addin from . Dummy Series Tricks Simulating Axis Types that Excel Doesn't Include Vertical Category Axis Tertiary Y Axis Arbitrary Axis Scale Arbitrary Gridlines Arbitrary Gridlines, Take Two Simulated Probability Chart Reciprocal Axis Chart Stacked Line Chart Waterfall Charts

MrExcel.com | Excel Resources | Excel Seminars | Excel Products Filled Histograms Using Excel XY-Area Charts I recently showed how to create Histograms Using Excel XY Charts. This technique produces a human-friendly numerical X axis scale, which is easier to read and harder to be deceived by than the bin labels used by column chart histograms. The drawback of that technique is that it produces histogram bars in outline only, without a fill color. In this post I will show how to extend that technique to fill the bars, using the protocol from Fill Below an XY Chart Series with an XY-Area Combination Chart. I started with the data from Histograms Using Excel XY Charts. The calculated values in the middle column are based on the small table to the right. Area Value = Area Scale Min + (Time - Time Min) / (Time Max - Time Min) * (Area Scale Max - Area Scale Min) or something like this, depending on where the tables are in the worksheet: We need to use both XY and Area chart types. So let’s make the chart. Copy the Area and Counts in the second and third columns, including the first and last row.