Archive for May, 2011
Is there a way to print all of the Visual Pricing Graphs in one easy step?
Yes, the Visual Pricing System has a “Print All Charts” feature that will allow you to print all the charts and graphs you’ve created in one easy step. To access the “Print All Charts” feature:
On Excel 2007 and Excel 2010, using the Menu’s select the Add-Ins –> Focus 1st –> Print All Charts…
On Excel 2003, use the Focus 1st –> Print All Charts…
Once you select the “Print All Charts” option you will see a dialog box similar to this:
Select the printer you want to print to. After selecting the printer you will see the following dialog box:
All of the charts and graphs created by the Visual Pricing System have been selected by default. If there are graphs/charts that you do not want to include you may unselect them. Once you’ve got the selection of charts you want to print out, press the “OK” button and your printing will occur.
Note: If you do not have the option to select charts to print, be sure to you have the most recent version of the Visual Pricing System. For information on Downloading the most recent version select this link.
If you are using the Primo PDF driver to create PDF files, printing multiple pages will work better if you have the ‘Post Processing’ option set to “Do Nothing” as shown below. For each page, you will still specify the filename. If you specify the same file name each time, you will have the option to append the printed page to the existing file.
The graphs currently show 2009 and 2010. It is currently 2011. When will 2011 graphs be created?
Graphs are created for two years. This is to help make identifying trends easier for you. Once you move into a new year, the applications 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 showing data for the new year would not provided enough information to be valuable. We think you would prefer to see the previous two years until there is enough data to make it worth looking the data for the new year.
So, how much data is enough? The Visual Pricing System will wait until the end of June before it moves to the next year. However, if you’d prefer to see the new years data plotted earlier, you can adjust the “Change Over Month” value. This is the month when the new year’s data will be plotted. You may easily change the “Change Over Month” value back and forth as you read data to get different years.
To set the “Change Over Month” value:
On Excel 2007 and Excel 2010, using the Menu’s select Add-Ins –> Focus 1st –> Configure
On Excel 2003, use the Focus1st –> Configure menu
You will see a dialog box similar to this:
Use the Drop Down menu to select the “Change Over Month”.