Bar chart set bar transparency

Description: Set bar chart transparency.
Assumptions: myVis is a visualization type script parameter.

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

myVisVC.Transparency = 0.5 # Range 0 to 1. Example 0.5
print "Bar Transparency: " + myVisVC.Transparency.ToString()

Bar chart show shadows for unfiltered data

Description: Show shadows indicating unfiltered data.
Assumptions: myVis is a visualization type script parameter.

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

myVisVC.ShowShadowBars = True # True or False
print "Show Shadow Bars: " + myVisVC.ShowShadowBars.ToString()

Bar chart use separate color for marked items

Description: Use separate color for marked items.
Assumptions: myVis is a visualization type script parameter.

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

myVisVC.UseSeparateColorForMarkedItems = False # True or False
print "Separate Color?: " + myVisVC.UseSeparateColorForMarkedItems.ToString()

Bar chart sort bars by value

Description: Sort bars by value.
Assumptions: myVis is a visualization type script parameter.

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

myVisVC.SortedBars = True # True or False
print "Sort Bars by Value: " + myVisVC.SortedBars.ToString()

Bar chart sort bar segments by value

Description: Sort bar segments by value.
Assumptions: myVis is a visualization type script parameter.

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

myVisVC.SortSegmentsBySize = True # True or False
print "Sort Segments by Size: " + myVisVC.SortSegmentsBySize.ToString()

Bar chart reverse bar segment order

Description: Reverse bar segment order.
Assumptions: myVis is a visualization type script parameter.

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

myVisVC.ReverseSegmentOrder = True # True or False
print "Reverse Bar Segment Order: " + myVisVC.ReverseSegmentOrder.ToString()

Compensate for missing time series values

Description: Compensate for missing time series values.
Assumptions: myVis is a visualization type script parameter.

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

myVisVC.CompensateForMissingTimeSeriesValues = True # True or False
print "Compensate: " + myVisVC.CompensateForMissingTimeSeriesValues.ToString()

Bar chart data table

Description: Display the bar chart's data table.
Assumptions: myVis is a visualization type script parameter.

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

print "Data Table Name: " + myVisVC.Data.DataTableReference.Name
print "Data Table Id: " + myVisVC.Data.DataTableReference.Id.ToString()

Bar chart marking

Description: Display the bar chart's marking info.
Assumptions: myVis is a visualization type script parameter.

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

print "Marking Name: " + myVisVC.Data.MarkingReference.Name
print "Marking Hex Color: " + myVisVC.Data.MarkingReference.Color.Name
print "Marking RGB Color: " + myVisVC.Data.MarkingReference.Color.ToString()

Bar chart limit data using expression

Description: Set limit data using expression.
Assumptions: myVis is a visualization type script parameter.

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

myVisVC.Data.WhereClauseExpression = "[Delta] > 20" #Delta is a column name
print "Limit data using expression: " + myVisVC.Data.WhereClauseExpression

Bar chart empty visualization from marking message

Description: Set the message shown when marking results in an empty visualization.
Assumptions: myVis is a visualization type script parameter.

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

myVisVC.Data.LimitingMarkingsEmptyMessage = "Select items on the chart"
print "Marking message: " + myVisVC.Data.LimitingMarkingsEmptyMessage

Bar chart title and ID

Description: Set, show, and hide the bar chart title. Also display the bar chart ID.
Assumptions: myVis is a visualization type script parameter.

myVis.Title = "Test123"
myVis.ShowTitle = not myVis.ShowTitle #True or False
print "Bar Chart ID: " + myVis.Id.ToString()

Bar chart description

Description: Set, show, and hide the bar chart description.
Assumptions: myVis is a visualization type script parameter.

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

myVisVC.Description = "Example description..."
myVisVC.ShowDescription = not myVisVC.ShowDescription #True or False

Add a new bar chart

Description: Add a new bar chart to the active page.

from Spotfire.Dxp.Application.Visuals import BarChart
myVis = Application.Document.ActivePageReference.Visuals.AddNew[BarChart]()
myDataTable = Document.Data.Tables["MyDataTable"]

myVis.Data.DataTableReference = myDataTable
myVis.Title = "New Bar Chart"
myVis.XAxis.Expression = "<"+str(myDataTable.Columns[0])+">"
#myVis.XAxis.Expression = "<[Date]>"
myVis.YAxis.Expression = "Sum(" + str(myDataTable.Columns[5]) + ")"
#myVis.YAxis.Expression = "Sum([Value])"

Remove a bar chart

Description: Remove all bar charts from the active page.

from Spotfire.Dxp.Application.Visuals import VisualTypeIdentifiers
activePage = Application.Document.ActivePageReference
  
for myVis in activePage.Visuals:
  if (myVis.TypeId == VisualTypeIdentifiers.BarChart):
    Application.Document.ActivePageReference.Visuals.Remove(myVis)

Locate all bar charts

Description: Locate all bar charts on all pages.

from Spotfire.Dxp.Application.Visuals import VisualTypeIdentifiers

for myPage in Document.Pages:
  for myVis in myPage.Visuals:
    if (myVis.TypeId == VisualTypeIdentifiers.BarChart):
      print "Bar Chart Name: " + myVis.Title
      print "Bar Chart ID: " + myVis.Id.ToString()

Switch visualization to bar chart

Description: Switch visualization to bar chart.
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualTypeIdentifiers

myVis.TypeId = VisualTypeIdentifiers.BarChart
#myVis.TypeId = VisualTypeIdentifiers.LineChart