LogoLogo
  • CHARTS USER GUIDE
    • Introduction
    • Angular Gauge Chart
    • Bar/Column Chart
    • Bubble Chart
    • Bullet Chart
    • Calendar Heatmap Chart
    • Column Range Chart
    • Combination Chart
    • Dumbbell Chart
    • Filter Chart
    • Funnel Chart
    • Grid Chart
    • Table heatmap
    • Histogram Chart
    • KPI Animation Chart
    • KPI Ring Chart
    • Line/Area line Chart
    • Mekko Chart
    • Packed Bubble Chart
    • Pie Chart
    • Polar Charts
    • Sankey Chart
    • Simple KPI Chart
    • Slope Chart
    • Sparkline Chart
    • Stacked Column/Bar
    • Text Node
    • Tornado Chart
    • Trellis Chart
    • Variwide Chart
    • Waffle Chart
    • Waterfall Chart
    • Wordcloud Chart
    • Workstation
    • Allow/Block URLs
    • Animation Duration
    • Attribute Forms
    • Auto Scroll
    • Axes
    • Background Images
    • Backward Compatibility
    • Bar/Column Width
    • Color Picker with Opacity
    • Connect Null Points
    • Custom Markers
    • Custom SVG Markers
    • Data Markers
    • Data label customization
    • Dossiers/Documents differences
    • Drilling
    • Error Bars
    • Export to PDF
      • Export engine local resource set up
    • Formatting metric data
    • Gradient Threshold
    • Legend
    • Negative Sign
    • Pattern Fill
    • Play Animation
    • Plot lines/Reference lines
    • Reset color property
    • Reset font properties
    • Right Click Menu
    • Right-to-left Support
    • Series using Attribute
    • Small Multiples
    • Smooth Line
    • Tooltip Customization
    • Tooltip Links
  • GRID/MICROCHART GUIDE
    • Appearance
    • Auto Size
    • Column Totals
    • Context Menu
    • Creating a micro chart
    • Custom markers
    • Custom Editor
    • Filter Data
    • Format/Clear Format
    • Grand Total
    • Pivoting and Row Grouping
    • Horizontal Bars/Pins
    • Embed Images
    • Manage Scaling Grouping
    • Manage Column Grouping
    • Manage Metric Grouping
    • Pin Column
    • Reorder columns
    • Reset Columns
    • Show/Hide Column
    • Sorting
    • Subtotals
    • Thresholds
    • Tooltip
    • Transparency
    • Trend Lines
    • Value Aggregation
    • Variance
  • MAPS USER GUIDE
    • Creating New Maps
    • Custom Layouts
    • Customization of the Map chart
    • Default Maps
    • Formatting Options
    • Generic Merge tool
    • US map using counties data
    • US Map using ZIP Codes
  • IBCS USER GUIDE
    • IBCS
      • Why IBCS
      • Mapping IBCS Scenarios
      • Negative Metrics
      • Scaling Multiple Charts
    • CERTIFIED CHARTS
      • Multi-tier Bar chart
      • Multi-tier Column chart
      • Small Multiples
      • Vertical Waterfall
  • CUSTOMIZATION GUIDE
    • Introduction
    • Custom CSS
    • Custom CSS Samples
    • Custom Color Palette
    • Custom Fonts
    • Condensed Metric Format
    • Disable Edit button
    • Grid Custom CSS
    • Localization
  • FAQ
    • Contact Us
    • FAQS
  • INSTALL DOCS
    • Installing on MicroStrategy Web
    • Installing on MicroStrategy Desktop/Workstation
    • Installing on MicroStrategy Library
    • Installing on MicroStrategy Mobile
    • Release Notes
    • Release Notes Maps
Powered by GitBook
On this page
  • 1. Using column header hamburger button.
  • 2. Using Edit button.

Was this helpful?

  1. GRID/MICROCHART GUIDE

Format/Clear Format

PreviousFilter DataNextGrand Total

Last updated 2 days ago

Was this helpful?

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 column header hamburger button.

Hover the cursor on the header of any column, at the right side corner you will find hamburger button.

Click on this button to open the column menu.

Click on the “Format” tab. When we click on “Format” tab, Vitara charts properies window will be opened showing “Format Column” properties.

2. 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.

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 as of Version 5.1.2. An illustration of a feature is shown below.

To remove applied formatting, user can access the 'Clear Formatting' option from the hamburger menu.

From 5.2 version 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