How to customize your Visual Pricing graphs!

The Visual Pricing System allows you to customize the Visual Pricing graphs with your own logo and your own footer.  When you do customize your graphs, the Focus1st Logo is removed and your logo/graphic is placed on each of the graphs (as shown below).


In this case, the graphic/logo that I’ve included is just my photo.  This graphic is now on each of the graphs and the Focus1st logo is removed.  Also, you may also customize the footer as well (see below).


Where normally, you’ll get the “” site address and the name of the chart printed at the bottom, here I’ve chosen to put in a web address, a phone number, and a tag line.  This is a great feature and is a great way to market yourself to your customers.

How to do customize your graphs.

The screens shots shown below are taken from a MAC running the Mojave OS, but the interface and the way you customize your graphs works the same way on the PC.

  • Using the Visual Pricing ribbon control, select the Configure option located at the right of the ribbon.
VPS Ribbon
  • The Configure dialog box will open.  Select the Replace Logo and Customize Footers command button (located near the top of the dialog box).  When you do you will see a dialog box similar to that shown below. [Note: if you do not see the Replace Logo and Customize Footers command button, you may need to download the latest Visual Pricing System release. You can easily do that by going to and login into your account.]
  • Select the Find Logo File to select the logo (or picture) you want to use.  Most graphic formats are acceptable.  Try to select a file that isn’t very large.  The graphic will be resized, but for large graphics they will still take up a lot of memory.  You are generally looking for a graphic near 50Kbytes or so.
  • Select the Setup Header/Footer and the select the Customize Footer to change the footer.
  • Once you’ve changed your logo and/or your footer, select the Save Changes button.  Your changes will be save and the Visual Pricing System will exit.  You will see a message similar to that shown below.

Once you select the OK button, the Visual Pricing System will close and your changes will take effect the next time you open and read in data (you may need to close the application if it doesn’t close by itself).

For MAC users only

The first time you open the Visual Pricing System after you’ve made changes, you may see a dialog box asking for permission to Grant Access to the logo file.


If you see this message, use the Select button and select the graphic you previously selected to add to your graphs and then select Grant Access.  Once you’ve done this, you won’t be asked to grant access again.

February 25, 2019 at 3:38 pm 1 comment

Average price per square feet calculated

The average price per square feet is now calculated automatically when you select the Show Selected Properties button.  The Show Selected Properties button is used to show only those properties that you have selected.  [Select this link to see a video on how to select data.]  The Show Selected Properties button is located in the Visual Pricing Ribbon as shown below.


Once you select the Show Selected Properties button, only those properties that you have selected will be shown.  Below those properties shown, the average price per square feet will be calculated and shown as well.  To show all the properties including those not selected, select the Show All Properties button.  Once you select this button all properties will be shown and the average price per square feet will disappear.

Note that the average price per square feet calculation shown is based on the option you have selected.  If you have selected to show the Total Square Feet, the average price per square feet will be based on Total Square Feet, as the same goes for Finished Square Feet and Above Ground Square Feet.  To see how to select the calculation you prefer select this link.

February 13, 2018 at 10:58 am Leave a comment

How to obtain the Price per Square Feet calculation based on other Square Feet options

With the latest release on both the PC and MAC, you can now calculate the price per square foot based on the Total Square Feet, Finished Square Feet, or *Above Grade Square Feet.  The default is that the price per Total Square Feet (if present for your MLS) is calculated on the MLS Data sheet.  This is shown on the last column and designated as Price per TSF.  However, if you’d like you can choose to have that last column be the price per Finished Square Feet (shown as Price per FSF) or price per *Above Ground Square Feet (shown as Price per AGSF).  To change to the calculation you prefer, go to the Configure dialog box by selecting the Configure button in the Visual Pricing Ribbon.  The Configure button is located on the right in the Visual Pricing Ribbon as shown below.


Once you select the configure button, you will see the Configure dialog box.  At the top of the box, select the Pricing tab.  Once you select the Pricing tab, you will see the dialog similar to that shown below.


Select the Price per Square Foot calculation that you prefer.  The next time you read in data, the MLS Data sheet will show the price per square foot option that you selected*.

If you do not see the dialog box shown above, it is likely that you need to download the latest release.  [To download the latest release go to and select the My Account menu item.  Log into your account and follow the instructions on the page to download the latest release.]

*The ability to support these options requires that your MLS is providing all that information to us.  If your MLS is not providing all three square footages, you will be limited to what your MLS is providing.

February 13, 2018 at 10:43 am 1 comment

The “Visual Pricing” and “Scattergram” ribbon tabs are missing.

In using the Visual Pricing system on the MAC 2016, we have seen a few times when the Visual Pricing and Scattergram tabs are missing.  When these tabs are missing you are unable to select any of the Visual Pricing buttons on the ribbon control, because they aren’t there.

We’ve noticed the when this is the case, it is because the Ribbon Control is not enabled.  As you can see from the menu below if you select the View menu item you will see the the Ribbon is not enabled.  When the Ribbon is enabled you will see a checkmark next to the Ribbon option (as you can see next to the Formula Bar option).


To enable the Ribbon option:

  1. First close the Visual Pricing System and quit the Excel 2016 program.
  2. Open up the Excel 2016 program, open up a default spreadsheet, and select the View->Ribbon option.  This will enable the Ribbon option.  You can verify that by selecting the View menu and noticing that the checkmark is next to the Ribbon option.
  3. Quit the Excel 2016 program and open up the Visual Pricing System.  You will now see that the View->Ribbon option is enabled and that the Visual Pricing and Scattergram tabs are present.

May 24, 2017 at 11:38 am Leave a comment

Can you please advise how I move the text boxes that I created for each of the properties on my scattergram? They are showing at the top of the scattergram but I want to move them to each property.

When you create the textboxes for the scattergram they are placed at the top left of the screen.  When we placed them near data points, they tend to hide other data points, and to make sure there weren’t data points being hidden you’d have to move everything off the graph to see and then move boxes back on.  So we decided to place the boxes at the top of the screen.

To move the text boxes:

  1. First select the text box by clicking on the text box you want to move. When you select the text box you will see smaller boxes that are shown near the edges and corners of the box that show that it is selected.
  2. Next move your cursor near the edge of the box, when you do you will see your cursor change to four arrows.  This shows that you are now ready to move the box.  Stay away from the corners (as shown by two arrows) since they will allow you to resize the box.  The boxes are already set to resize based on the text inside them and resizing them yourself will change this characteristic.  Once you get the four arrow you can use your left mouse button to drag the box to where you want it.

To see a demo of how this works, select this link and fast forward to the 10 minute mark it will show you how its done.   [Select this link to show the video now.]

Also be aware, that you may easily delete boxes that you don’t need or want.  To delete a box, just select that box, and then hit the delete key.  Be sure that you select the box by pressing the left mouse button when you see the four arrows.  If you see the “I-Beam” cursor you have text in the box selected (which you may also want to do) and hitting the delete button at that time will delete text.  You may also delete multiple boxes by selecting a box, holding down the shift key, and selecting additional boxes.  Once you’ve selected the boxes you want deleted, press the delete button.

May 18, 2017 at 8:49 am Leave a comment

Now that it is 2019, how do I get Visual Pricing System to show 2019 graphs?

To show 2019 data, no upgrade is necessary.   In most cases, the Visual Pricing System application shows data for only two years.  This is to help make identifying trends easier for you.  Once you move into a new year, the application will look to display data for the new year.  However, in the beginning of the new year, the amount of data is small enough that moving to the new year right away would not provide enough information to be valuable.  We think you would prefer to see the previous two years until there is enough data to make sense to move to the next year.

So, how much data is enough?  The program will wait until after the end of June (month 6) before it decides to move to the next year.   However, if you’d prefer to see the new year’s data plotted earlier (or later) you can adjust the Change Over Month value.   This is the month when the new year’s data will be plotted.  Of course, you may easily change the Change Over Month value back and forth if you’d like.  Once you modify the value for the Change Over Month you will need to read in the data again.  The new results will reflect the change that you made.

To change the Change Over Month you will need to change the configuration parameters.  The configuration parameters can be set using the Configure dialog box.  To see the Configure dialog box, first go to the Visual Pricing tab located at the top of the program.  Then select the Configure button as shown below.


You will then see the Configure dialog box.  There is where you can change the value of the Change Over Month.

Select a month has already past (for example if this month is March, then select February [or 2]).  Then press the “OK” button.   The change will be effective when you read in your next export file.

May 17, 2017 at 10:55 am Leave a comment

The DOM (Days on the Market) that is reported on the MLS Data sheet differs from what is reported from my MLS. Why is that and can I make it the same?

We have found with our work that the DOM reported by MLS’s is not consistent.  While most Realtors believe that the DOM is the same as the Sold Date minus the List Date, we have found that, that is not always the case.  In some cases, the DOM stops incrementing when the property is put it a “pending” state but not when it is put “under contract”.
As a result, we calculate the DOM by taking the Sold Date and subtracting the List Date and putting that value in the DOM column.  However, if you’d like you can place the actual DOM value that is provided by the MLS instead of the calculated value we provide.  To do that all you need to do is to set the “Use DOM from MLS instead of the calculation” option.  That option can be found on the Config dialog box, and then selecting the Pricing tab.
You can find the config dialog box on the PC and the MAC located in the Visual Pricing Ribbon.  For older versions (in case you don’t want to download the more recent versions):
  1. Go to the start page (select the “start” tab below.
  2. Then at the top of the menus, select the “Add-Ins” menu and the “Focus 1st” menu will drop down below.
  3. Using the “Focus 1st” menu, select the “Configure” option.
  4. Then select the “Pricing” tab on top to find the option.
 On the MAC, select the settings wheel, and the “Configure” dialog box will show.  Select the “Pricing” tab on top to find the option
NOTE: When you decide to use the DOM from the MLS instead of the calculation, the list date is back dated based on the DOM value.  This is to allow the Time to Sell graph to be consistent.

November 7, 2016 at 8:49 am Leave a comment

Older Posts

October 2019
« Feb    


Recent Posts

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 70 other followers