Celebrate the launch of Pine BI 2.0 with 20% off! Use code: PBI2NOW.

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.

Elements

Total Difference Arrow
Level Difference Arrow
Value Line
Category Line
Stacked Column Total

Variance Charts

Simple Column/Pin Variance
Line Variance
Advanced Column Variance
(6 versions)

Cards

Column/Area/Line Card
Card with Coomparison Table

Gauges

Donut Chart (3 versions)
Dynamic Color Donut Chart
Speedometer (2 versions)
Dynamic Color Speedometer
Zone Speedomter
Score Meter

Waterfall Charts

Horizontal/Vertical Waterfall
Stacked Waterfall

Project Management Charts

Gantt With Progress
RAG

Other Charts

Column/Line Min/Max
Column/Pin Income/Expense
Difference
Cycle Plot
Slider
Dumbbell
Forecast
Lollipop
Slope
Step
Tornado

Charts & Visualizations

Click on a feature below for detailed description and guidelines:

Layout	The Layout Menu lets you transform your Excel workbook into a truly engaging and dynamic dashboard by adding a navigation menu, worksheet background, and more.	See More
Chart Editor	The Chart Editor enables users to edit one or multiple charts simultaneously and optimize the layout of a dashboard.	See More
Elements	Elements such as total and level difference arrows, CAGR indicators, value and category lines, shaded areas, and stacked totals are versatile tools that enhance data visualization by highlighting key metrics, trends, and relationships within a dataset, making complex information easier to interpret.	See More
Gauges	Gauges are ideal for measuring performance against a set target. They are highly popular, and it's rare to find a KPI dashboard without at least one.	See More
Simple Actual Vs. Target Charts	Actual vs. Target Charts are excellent tools for visually representing performance relative to a predefined target.	See More
Advanced Actual Vs. Target Charts	Advanced Actual vs. Target Charts deliver deeper insights by enabling users to track trends, analyze deviations, and highlight areas for improvement with greater precision.	See More
Simple Variance Charts	Variance Charts clearly highlight differences between actual results and targets, helping to track performance and identify gaps at a glance.	See More
Advanced Variance Charts	Advanced Variance Charts provide detailed insights into the differences between actual results and targets, offering enhanced clarity and depth for performance analysis and decision-making.	See More
Project Management Charts	Project management charts are essential for managing and tracking a project's status. They are also highly valuable for effectively communicating a project's phase and overall progress to an audience.	See More
Waterfall Charts	Waterfall charts effectively illustrate the cumulative impact of sequential positive and negative values. While they are notoriously challenging to create in Excel, we've developed exceptional Waterfall charts that are feature-rich and highly adaptable.	See More
Min/Max Charts	Min/Max charts are a valuable addition to dashboards, helping to highlight the highest and lowest values in a dataset, making it easier to identify key trends and outliers at a glance.	See More
Income/Expense Charts	Income/Expense charts are helpful for visualizing financial performance, providing a clear comparison of earnings and expenditures to aid in budgeting and decision-making.	See More
Difference Charts	Difference charts are useful for visualizing the magnitude of change between periods, helping to clearly highlight trends, fluctuations, and overall progress over time.	See More
Cycle Plot	Cycle plots are effective for analyzing patterns and trends within recurring periods, making it easier to identify seasonal variations and long-term shifts in data over time.	See More
Slider Charts	Slider visuals resemble a sliding scale and effectively display data values, allowing for an intuitive representation of ranges, progress, or specific data points.	See More
Dumbbell Charts	Dumbbell charts are an excellent way to visualize changes or differences between two data points, effectively highlighting the range or progress while maintaining clarity and simplicity in presentation.	See More
Forecast Charts	Forecast charts are valuable tools for visually comparing actual performance against planned targets, enabling users to assess progress and predict future trends.	See More
Lollipop Charts	Lollipop charts are a sleek and effective way to compare data points, using a combination of dots and lines to emphasize differences or highlight specific values within a dataset.	See More
Slope Charts	Slope charts are an effective way to compare changes between two points in time or categories, using lines to clearly highlight trends, rankings, or shifts in data.	See More
Step Charts	Step charts are ideal for displaying data that changes at irregular intervals, using a stepped line to clearly represent shifts and hold periods between data points.	See More
Tornado Charts	Tornado charts are effective for comparing the relative impact of different variables, using horizontal bars to clearly visualize sensitivity or significance in a dataset, often for risk analysis or decision-making.	See More
Cards	Cards are an essential component of a dashboard, helping the audience focus on key data points and guiding them through the data analysis process.	See More
Settings	The Settings menu allows the user to activate and manage the Pine BI license.	See More

Key Features

50+ Visualization types
100+ Chart combinations
Easily create charts from:
- Normal Excel Data Ranges
- Excel Tables
- Pivot Tables
- Horizontal/Vertical Data Ranges
All Visualizations are dynamic and are updated in real time.
Easy to edit - all charts can be edited just like the default Excel charts
Easy to share in PowerPoint or Word
Users without Pine BI will still be able to see, use and edit the charts.

Requirements

Publisher: Pinexl Ltd.

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

Supported Excel Version: Excel 2007 or newer**

Date Published: 16 April 2020

Current Version: 2.0

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

See Pricing

Use Cases

SATISFIED CUSTOMERS FROM 30+ 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.