VitaraCharts for ThoughtSpot
  • CHART USER GUIDE
    • Angular Gauge Chart
    • Bar/Column Chart
    • Combination Chart
    • Dumbbell Chart
    • Funnel Chart
    • Grid Chart
    • KPI Animation Chart
    • Line/Area line Chart
    • Pie Chart
    • Polar Charts
    • Slope Chart
    • Sparkline Chart
    • Stacked Column/Bar
    • Tornado Chart
    • Variwide Chart
    • Waffle Chart
    • Add as Filter
    • Allow/Block URLs
    • Auto Scroll
    • Axes
    • Background Images
    • Bar/Column Width
    • Color Picker with Opacity
    • Connect Null Points
    • Custom Markers
    • Data Markers
    • Data label customization
    • Download Answers
    • Error Bars
    • Export to PDF.
    • Formatting metric data
    • Gradient Threshold
    • Gradient Color
    • Legend
    • Negative Sign
    • Pattern Fill
    • Play Animation
    • Plot lines/Reference lines
    • Reset color property
    • Reset font properties
    • Right Click Menu
    • Series using Attribute
    • Small Multiples
    • Smooth Line
    • Tooltip Customization
    • Tooltip Links
  • GRID CHART GUIDE
    • Appearance
    • Auto Size
    • Column Totals
    • Custom markers
    • Custom Editor
    • Filter Data
    • Format/Clear Format
    • Grand Total
    • Pivoting and Row Grouping
    • Horizontal Bars/Pins
    • Manage Scaling Grouping
    • Manage Column Grouping
    • Manage Metric Grouping
    • Pin Column
    • Reset Columns
    • Show/Hide Column
    • Sorting
    • Subtotals
    • Thresholds
    • Tooltip
    • Trend Lines
    • Value Aggregation
  • CUSTOMIZATION GUIDE
    • Custom CSS
    • Custom CSS Samples
    • Custom Color Palette
    • Custom Fonts
    • Condensed Metric Format
    • Grid Custom CSS
  • INSTALL DOCS
    • Production Deployment
    • Trial Deployment
  • FAQ
    • Contact Us
    • FAQS
      • How we can do export to PDF
      • How can we define a custom color palette?
      • How can we define and use a new font?
      • How can customers reach Vitara technical support team?
      • How can I find the version of Vitaracharts installed?
      • Where can I find the chart state information?
Powered by GitBook
On this page
  1. GRID CHART GUIDE

Format/Clear Format

PreviousFilter DataNextGrand Total

Last updated 6 months ago

Properties Menu - Format/Clear Format

The text styles we apply using the ‘Grid Theme’ tab will reflect the entire grid i.e all rows and all columns. Whereas the text styles and background color we apply for any column using the ‘Format’ tab will affect only that particular column. As shown in the below screenshot we can access ‘format’ or ‘clear format’ options from the hamburger button of any column.

We can open column formatting menu in two ways. 1. Using Edit button. Hover the cursor on the grid chart to display “Edit” button. Click on the “Edit” button to open vitara properties window. Open the “Format Column” menu.

Note: The properties applied using the ‘Format’ tab for a particular column, will overwrite the properties applied using the “grid Theme’ tab for that column. The ‘Clear Formatting’ tab will delete all the formatting applied on that particular column.

Example:

In the below screenshot vitara grid chart is displaying the data for current year Profit, last year’s Profit, current year Units sold and last year’s Units sold.

To differentiate the current year and previous year columns, i want to apply Blue Color for the current year metrics and Red Color for the previous year metrics.

Open the “Format Column” menu using one of the two ways discribed above. In the ‘Select Column’ drop down box select the column for which you want to apply specific formattings.

In the “Format For” drop down box select the part of the column (header or body) to which you want to apply formatting.

Apply the text formattings and finally click on ‘Apply’ tab.

Below is the screenshot of the grid chart in which current year metrics are given blue color and last year metrics are given red color.

The user can now apply formatting to horizontal bars and pins . An illustration of a feature is shown below.

To remove applied formatting, users can access the “Clear Formatting” option from the hamburger menu.

User can now an ability to access the custom editor from the hamburger menu by clicking the format button.For more details please refer to the

Custom Editor