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

Consulting And Development Services Consulting And Development Services This page describes my consulting and application development services. Pearson Software Consulting provides consulting and project development services for Excel, Visual Basic, and VB.NET. We can create new applications leveraging the power of Excel and Visual Basic For Applications (VBA), Visual Basic (VB6) and VB.NET with the .NET Framework. Products we offer include customized workbooks, templates, XLA Add-Ins, COM Add-Ins, Automation Add-Ins, and complete applications based in Excel, Visual Basic, or VB.NET. We work with individuals on small projects and with major corporations that need an entire application linking together multiple Office applications. Development rates are $150 per hour or we can arrange a flat-rate fee for a project. In addition to application development, we also offer ad-hoc consulting to provide answers and advice. Services we can provide include Payment may be made by Master Card and Visa or by PayPal.

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.

Track Project Progress with Physical % Complete - MPUG Written by Eoin Callan Eoin J.P. Callan, MBA, PMP, MCTS, MCT, has witnessed firsthand the practical application of disciplined project management for over 15 years in thousands of projects. His career reflects a broad application of portfolio, program, and project management skills. He's worked internationally in verticals including call centers, financial services, marketing, pharmaceuticals, and software development. Reach him at eoin.callan@useepmright.com. Far too often people arbitrarily track project performance through the “Percent (%) Complete” method with subjective estimates for “how finished” the project is. The Physical % Complete field is included by default in the Tracking Table (View | Table | Tracking) or it can be inserted into any Task-oriented view (Insert | Column | “Physical % Complete” in the Field name: field). Figure 1: A template example showing a Physical % Complete field inserted in the Entry table. Click OK | OK. IIf([Number1]<>0,[Number2]/[Number1]*100,0)