Using the FileSystemObject (FSO) in Excel VBA The FileSystemObject (FSO) gives you access to a whole range of functions for accessing your computer’s file system. Using this object, you can easily access files, folders, and drives, and also read and write to files. Many of the FSO functions could be written by you in traditional… Continue Reading
In this ArticleVenn Diagram – Free Template DownloadGetting StartedPrep Chart DataStep #1: Find the number of elements belonging exclusively to one set.Step #2: Compute the chart values for the intersection areas of two circles.Step #3: Copy the number linked to the intersection area of three sets into column Chart Value.Step #4: Outline the x- and… Continue Reading
In this ArticlePolar Plot – Free Template DownloadGetting startedStep #1: Set up a helper table.Step #2: Compute the Angle (theta) values.Step #3: Compute the Radius values.Step #4: Copy the last Radius values into the helper row.Step #5: Calculate the x- and y-axis values for each company.Step #6: Set up the second helper table for the… Continue Reading
This tutorial will discuss VBA UserForms. VBA UserForms The Userform is a very important part of programming in VBA. It allows you to build a professional looking user interface to communicate with the users of your VBA application. It also allows you to totally control the user in what they are doing to your workbook.… Continue Reading
In this ArticleStem-and-Leaf Plot – Free Template DownloadGetting StartedStep #1: Sort the values in ascending order.Step #2: Set up a helper table.Step #3: Find the “Stem” values.Step #4: Find the “Leaf” values.Step #5: Find the “Leaf Position” values.Step #6: Build a scatter XY plot.Step #7: Change the X and Y values.Step #8: Modify the vertical… Continue Reading
Using a VBA ArrayList An ArrayList is a VBA object that can be used to store values. It is similar to a Collection object, but it has far greater flexibility from a programming point of view. Let’s discuss some difference between ArrayLists and Collections and Arrays. The Collection object only has two methods (Add, Remove)… Continue Reading
In this ArticleMekko Chart – Free Template DownloadGetting StartedStep #1: Set up a helper table.Step #2: Add the market segment data to the helper table.Step #3: Fill in the buffer rows.Step #4: Set the custom number format for the horizontal axis data column.Step #5: Compute and add the segment percentages to the axis column.Step #6:… Continue Reading
In this ArticleBullet Graph – Free Template DownloadGetting StartedStep #1: Plot a stacked column chart.Step #2: Change the axis labels.Step #3: Create a combo chart and push Series “Target” and Series “Actual” to the secondary axis.Step #4: Delete the secondary axis.Step #5: Create the markers for Series “Target.”Step #6: Adjust the gap width for the… Continue Reading
In this ArticleStep Chart – Free Template DownloadGetting StartedStep #1: Clone the original data table.Step #2: Duplicate all the values in the cloned table.Step #3: Sort the table by the date column from oldest to newest.Step #4: Shift the cost values one cell downward.Step #5: Remove the first and last rows of the duplicate table.Step… Continue Reading
This tutorial will demonstrate how to create and edit Bar Charts in Excel. Bar Chart – Free Template Download Download our free Bar Chart Template for Excel. Download Now A bar chart is essentially a column chart turned on its side. Like column charts, bar charts are great for comparisons. However, bar charts tend to… Continue Reading
