Bar chart color expression

/

Description: Configure bar chart color expression.
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent
myVisVC = myVis.As[VisualContent]()

myDataTable = myVisVC.Data.DataTableReference 
#myDataTable = Document.Data.Tables["MyDataTableName"]

myVisVC.ColorAxis.Expression = "["+str(myDataTable.Columns[2]) +"]"
#myVisVC.ColorAxis.Expression = "[Category]"

Bar chart color mode fixed

/

Description: Set bar chart color for color mode fixed.
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent
from System.Drawing import Color
myVisVC = myVis.As[VisualContent]()

#Set the color when using color mode fixed
myVisVC.ColorAxis.Coloring.DefaultColor = Color.FromArgb(255,155,100) #"All values" color
#myVisVC.ColorAxis.Coloring.DefaultColor = Color.FromName("Black")    #"All values" color
myVisVC.ColorAxis.Coloring.EmptyColor = Color.FromArgb(0,0,0)         #"Empty values" color

Bar chart value axis

/

Description: Configure bar chart value axis (y-axis).
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent
myVisVC = myVis.As[VisualContent]()
myDataTable = myVisVC.Data.DataTableReference
 
myVisVC.YAxis.Expression = "Sum(["+str(myDataTable.Columns[5])+"])"
#myVisVC.YAxis.Expression = "Sum([Delta])"

Bar chart value axis scale direction

/

Description: Toggle bar chart value axis scale (normal or reverse scale).
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent
myVisVC = myVis.As[VisualContent]()

myVisVC.YAxis.Scale.Reverse = not myVisVC.YAxis.Scale.Reverse
#myVisVC.YAxis.Reversed = not myVisVC.YAxis.Reversed #Also works

Bar chart value axis label orientation

/

Description: Set bar chart value axis label orientation.
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent, LabelOrientation
myVisVC = myVis.As[VisualContent]()

myVisVC.YAxis.Scale.LabelOrientation = LabelOrientation.Vertical #Vertical or Horizontal

Bar chart fonts

/

Description: Configure bar chart fonts.
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent
from System.Drawing import Font, FontStyle
myVisVC = myVis.As[VisualContent]()

#Default Font
myVisVC.DefaultFont = Font(Font("Arial",12),FontStyle.Bold)
#Label Font
myVisVC.LabelFont = Font(Font("Arial",12),FontStyle.Bold)
#Legend Font
myVisVC.Legend.Font = Font(Font("Arial",12),FontStyle.Bold)
#Trellis Header Font
myVisVC.Trellis.HeaderFont = Font(Font("Arial",12),FontStyle.Bold) 
#Future fonts: Line&curve labels
#Future Application preferences fonts: Description, Details visualization message

Bar chart category axis

/

Description: Configure bar chart category axis (x-axis).
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent
myVisVC = myVis.As[VisualContent]()
myDataTable = myVisVC.Data.DataTableReference
  
myVisVC.XAxis.Expression = "<["+str(myDataTable.Columns[0])+"]>" #Ex1
#myVisVC.XAxis.Expression = "<[Date]>"                           #Ex2
#myVisVC.XAxis.Expression = "["+str(myDataTable.Columns[0])+"]"  #Ex3
#myVisVC.XAxis.Expression = "[Date]"                             #Ex4

Bar chart category axis label orientation

/

Description: Set bar chart category axis label orientation.
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent, LabelOrientation
myVisVC = myVis.As[VisualContent]()

myVisVC.XAxis.Scale.LabelOrientation = LabelOrientation.Vertical #Vertical or Horizontal

Bar chart category axis zoom slider range

/

Description: Set bar chart category axis zoom slider range.
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent, AxisRange
myVisVC = myVis.As[VisualContent]()

#AxisRange Constructor: AxisRange(Object low, Object high)
myVisVC.XAxis.ZoomRange = AxisRange(10,200)

Bar chart category axis transform type

/

Description: Set bar chart category axis transform type (log or none).
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent, AxisTransformType
myVisVC = myVis.As[VisualContent]()

#The below is only visible with a continuous axis and not a categorical axis
myVisVC.XAxis.TransformType = AxisTransformType.Log10 #.None or .Log10

Bar chart category axis scale direction

/

Description: Toggle bar chart category axis scale (normal or reverse scale).
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent
myVisVC = myVis.As[VisualContent]()

myVisVC.XAxis.Scale.Reverse = not myVisVC.XAxis.Scale.Reverse
#myVisVC.XAxis.Reversed = not myVisVC.XAxis.Reversed #Also works

Bar chart set bar orientation

/

 

Description: Set the bar chart orientation as vertical or horizontal bars.
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent, BarChartOrientation
myVisVC = myVis.As[VisualContent]()

myVisVC.Orientation = BarChartOrientation.Vertical 
#myVisVC.Orientation = BarChartOrientation.Horizontal 
print "Bar Orientation: " + myVisVC.Orientation.ToString()

Bar chart set stack mode layout

/

Description: Set bar chart stack mode layout to side-by-side, stacked, or 100% stacked bars.
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent, StackMode
myVisVC = myVis.As[VisualContent]()

myVisVC.StackMode = StackMode.None #Options: None, Stack, Stack100Percent
print "Bar Layout: " + myVisVC.StackMode.ToString()