:: Subscribe to our newsletter
 
02/10/2012
Latest version of TraderCode(v5.5) includes new Technical Analysis indicators, Point-and-Figure Charting and Strategy Backtesting.



1/04/2011
InvestmentCode, a comprehensive suite of
Financial calculators and models for Excel is now available.



9/01/2009
Launch of
Free Investment and Financial Calculator for Excel.



1/02/2009
Launch of NeuralCode(v1.0) for
Neural Networks Trading.



8/06/2008
Launch of ConnectCode Excel Training Courses. Get this
Free Excel Training (over 100 pages) now.



7/23/2008
ConnectCode Text Manager - add-in that enhances your productivity when working with text in Excel.



6/17/2008
ConnectCode Number Manager - add-in that enhances your productivity when working with numbers in Excel.



6/3/2008
ConnectCode Barcode Font Pack - enables barcodes in office applications and includes an add-in for Excel that supports mass generation of barcodes.



2/1/2008
Release of
SparkCode Professional - add-in for creating Dashboards in Excel with sparklines



12/15/2007
Announcing
ConnectCode Duplicate Remover - a powerful add-in for finding and removing duplicates entries in Excel



09/08/2007
Launch of
TinyGraphs - open source add-in for creating sparklines and tiny charts in Excel.

SparkCode Professional - Column Charts

Option dialog for Column Charts.

Supported Options

Column Color - click the color box to set color for the columns

Color - select the appropriate checkbox to change colors for the Start, End , Minimum or Maximum columns

  • Start Color - click the color box to set color for the Start column
  • End Color - click the color box to set color for the End column
  • Minimum Color - click the color box to set color for the column with Minimum value
  • Maximum Color - click the color box to set color for the column with Maximum value

Scale - Three scaling modes are available for column charts.

  • Normal - create a spark column graph based on the minimum and maximum values of the data series. Positive values in the data series will be mapped to a positive column and negative values will be mapped into a negative column.
  • Map all values into the range 0 to 100 - create a spark column graph by mapping the minimum and maximum value of the data series into the range 0 to 100. The smallest value will be mapped to 0 and the maximum value to 100. All columns will be positive columns.
  • Map all values into the range 0 to -100 - create a spark column graph by mapping the maximum and minimum value of the data series into the range 0 to -100. The smallest value will be mapped to -100 and the maximum value to 0. All columns will be negative columns.

The following image shows the three scaling modes applied to the same data series.

Notice for the mode Map all values into the range 0 to 100, all the columns will be positive even though the data series contains several negative numbers.

Notice for the mode Map all values into the range 0 to -100 , all the columns will be negative even though the data series contains several positive numbers.


 


Copyright (c) 2007-2015, ConnectCode Pte Ltd. All Rights Reserved.


Trademark Acknowledgements

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. All other product names are trademarks, registered trademarks, or service marks of their respective owners