Pine BI - Details

How to Create Your Chart?

Adding a chart with Pine BI is easy - you can create one based on your own data, or add a template, which you can adjust to fit your needs.

How to Edit Your Chart?

Pine BI is built on entirely native Excel features. Therefore, you can edit all charts just like the default Excel ones.

How to Share Your Chart?

Users without Pine BI will still be able to see and edit the charts you've created. Charts can be easily copied to PowerPoint and Word.

What's Included

Gauges

Donut Gauge Chart

Speedometer (3 versions)

Actual Vs. Target Charts

Simple Bullet

Full Overlap

Partial Overlap

Thermometer

Column with Markers

Dynamic Color

Line/Area Threshold

Variance Charts

Column/Bar

Pin/Lollipop

Advanced (2 versions)

Project Management Charts

Gantt With Progress

Milestone

RAG

Forecast Charts

Simple Forecast

Forecast With Confidence Interval

Waterfall Charts

2 Versions

Horizontal/Vertical

Cards

Heat Maps

Sequential

Diverging

Navigation Menu

Other Charts

Min/Max

Income/Expense

Bullet

Tornado

Layout

The Layout Menu let's you turn your Excel Workbook in a truly engaging and dynamic dashboard by adding a navigation menu, worksheet background and more.

Chart Editor

The Chart Editor allows users to edit one or multiple charts at once and to optimize the layout of a Dashboard.

Gauges

The Gauges are perfect for measuring performance against a set target. They are very popular and you can hardly find a KPI Dashboard without at least one. Overall we have included 4 Gauge types - 1 Donut and 4 different Speedometers.

Actual Vs. Target Charts

Actual Vs. Target Charts are great to visually represent performance, measured against a predefined target.

Variance Charts

Variance charts show by how much the actual results differ from a target.

Forecast Charts

Forecast charts help to visually represent actual vs planned performance.

Waterfall Charts

Waterfall charts help visually represent the cumulative effect of sequential positive and negative values. They are also notoriously difficult to create in Excel. Still, we've managed to create amazing Waterfall charts that have many features and are very flexible.

Project Management Charts

Project Management charts help manage and track the status of a project. They are also very valuable when communicating a project's phase and overall status to an audience.

Other Charts

Pine BI offers a lot more charts, which can be helpful in a variety of situations - from Dashboards to Presentations.

Cards

Cards are important part of a Dashboard. They help the audience focus on the most important data and guide the viewer through the Data Analysis process.

Heat Map

Heat Maps are great for Data Analysis, when a large amount of data must be compared at a single glance. 

Settings

The Settings menu allows the user to activate and manage the Pine BI license.

Key Features

  • Easily create charts from:

    • Normal Excel Data Ranges

    • Excel Tables

    • Pivot Tables

    • Horizontal/Vertical Data Ranges

  • The data ranges don't have to be in a specific order - they can even be in separate sheets!

  • All Charts are dynamic and are updated in real time

  • Easy to edit - all charts work just like the default Excel charts

  • Easy to share in PowerPoint or Word

  • Users without the Add-In will still be able to see, use and edit the charts

Requirements

Publisher: Pinexl Ltd.

Supported OS: Windows 7 SP1 or higher*, Windows 8, Windows 10. Both 32/64 bit.

Supported Excel Version: Excel 2007 or newer**

Date Published: 16 April 2020

Latest Update: 06 June 2020

Current Version: 1.1

* If you are using Windows 7, make sure you have Service Pack 1 installed. Pine BI cannot be activated otherwise.

** Waterfall charts, some Actual vs. Target charts and some Other charts  work best in Excel 2013 or newer. Please refer to the detailed overview above for additional information.

SATISFIED CUSTOMERS FROM 10+ COUNTRIES

Alexander Y.

"Amazing design and value! Waiting for the next products!"

"I've been using Pinexl dashboards for a few months and love them and the detail they display!"

Steve Sunder

President Sunder Vision Solutions

"Amazing! This would really help me a lot in my new role! Looking forward to more such creative dashboards!"

Mohamed F.

Copyright © 2018 - 2020 PINEXL Ltd.