Knowledge Base
Zebra BI for Excel

Style Editor: Branded Formatting of Excel Charts and Tables

Applies to:
Zebra BI Tables for Excel
Zebra BI Charts for Excel

In this article, we will guide you through the process of applying Style Editor, one of Zebra BIs’ key features, using JSON theme for amplified corporate branding within your Excel charts and tables.

A JSON theme offers an accessible way to customize visual components like color schemes, typefaces, and layout configurations. This, in turn, ensures alignment with your organization’s unique brand identity.

Step 1 – Save the existing theme from the Add-in

Zebra BI comes with built-in themes and designs that follow IBCS standards. But we also understand the importance of company branding. That’s why we’ve included the Style Editor feature in our Starter, Advanced, and Enterprise plans, allowing you to customize your dashboards and presentations.

To start making changes, simply click on the Gear icon in the top right corner. This takes you to the settings menu where you can modify existing settings to fit your brand.

After you have finished personalizing the visual you can click on the “Save theme” button at the top of the settings.

This will open a new window with the JSON theme code which can be copied. In the next steps, we’ll show you how to apply this throughout all Zebra BI add-ins.

Step 2 – Access the Style editor

When you want to apply your own JSON theme you will first need to visit the Style editor page to apply your company branding to all reports.

Step 3 – Sign in with your Microsoft account

The link above will redirect you to the page where Signing in to the Microsoft account is required.

Step 4 – Copy & Paste your JSON inside the box

Once you’ve signed in the editor appears where you can paste in an existing theme or edit the one that is already inserted.

Step 5 – Save your style

When you’re done with the editing, click on the “Save style” button, and the “Style saved” text will inform you that the changes have been saved to your account and consequently also to the whole company via domain.

Step 6 – Check if your reports are updated with appropriate styles

Now it’s time to check out the theme you’ve saved in the editor. Open your Excel workbook and insert any Zebra BI add-in. You can do this by following the next steps:

  • Click anywhere inside the table
  • Move to the Home tab > Add-ins
  • Select any of the two Zebra BI add-ins for Office

Selecting a Zebra BI add-in will lead you to the Chart Chooser, where various chart types are available for you to choose from and all of them come with additional descriptions.

When any chart is selected the theme you’ve set up earlier will immediately get applied in the newly created visual. If you would like to modify this new theme you can simply go back to Settings, make changes and click on “Save theme” again, return to the Style editor, and repeat the process.

Was this article helpful?

Next Article

Changing Layouts