Pine BI Excel Add-In 产品特点

Transform workbooks into modern dashboards.
Layout
Edit one or multiple charts at the same time.
Pine BI Chart Editor
Create Data Gauge visualizations in seconds.
Pine BI Gauges
Create dynamic Actual vs. Target Charts in Excel.
Pine BI Actual vs. Target Charts
Create dynamic variance charts in Excel.
Pine BI Variance Charts
Create dynamic forecast charts in Excel.
Pine BI Forecast Charts
Create dynamic waterfall charts in Excel.
Pine BI Waterfall Charts
Create dynamic project management charts in Excel.
Project Management Charts
Create dynamic charts in Excel.
Pine BI Other Charts
Create dynamic Heat Maps in Excel.
Pine BI Heat Maps
Create dynamic Data Cards in Excel.
Pine BI Cards
Transform workbooks into modern dashboards.

Transform workbooks into modern dashboards.

From the Layout section, users can add a workbook navigation menu in seconds, change worksheet background colors and hide/show the workbook sheet tab, for an immersive dashboard experience.

The navigation menu will add a navigation pane to the left of all visible sheets, allowing for easier and logical navigation in the workbook, just like in a modern dashboard tool. The navigation menu can later be automatically removed from the same tool.

Edit one or multiple charts at the same time.

Edit one or multiple charts at the same time.

With the Pine BI Chart Editor users can modify one or multiple charts at the same time, split data series, arrange them in a grid and copy formats, thus saving time from tedious tasks allowing users to spend more time on the actual data analysis.

The Chart Editor works with normal and Pivot charts and all charts edited with it will remain dynamic and shareable.

Create Data Gauge visualizations in seconds.

Create Data Gauge visualizations in seconds.

From the Pine BI Gauges menu, users can create donut-based gauges and three different types of speedometers. All visualizations remain dynamic and can be shared with other users or in PowerPoint.

Create dynamic Actual vs. Target Charts in Excel.

Create dynamic Actual vs. Target Charts in Excel.

From the Pine BI Actual vs. Target Charts menu, users can create 7 different AvT charts. Two of them are with dynamic colors, which change based on the result.

All visualizations remain dynamic and can be shared with other users or in PowerPoint.

Create dynamic variance charts in Excel.

Create dynamic variance charts in Excel.

From the Pine BI Variance Charts menu, users can create 4 different variance charts with different levels of complexity.

All visualizations remain dynamic and can be shared with other users or in PowerPoint.

Create dynamic forecast charts in Excel.

Create dynamic forecast charts in Excel.

From the Pine BI Forecast Charts menu, users can create 2 different forecast charts with different levels of complexity.

All visualizations remain dynamic and can be shared with other users or in PowerPoint

Create dynamic waterfall charts in Excel.

Create dynamic waterfall charts in Excel.

From the Pine BI Waterfall Charts menu, users can create 3 different waterfall charts with different levels of complexity.

All visualizations remain dynamic and can be shared with other users or in PowerPoint.

Create dynamic project management charts in Excel.

Create dynamic project management charts in Excel.

From the Pine BI Project Management Charts menu, users can create 3 different project management charts: Gantt chart, Milestone chart and RAG Chart.

All visualizations remain dynamic and can be shared with other users or in PowerPoint.

Create dynamic charts in Excel.

Create dynamic charts in Excel.

From the Pine BI Other Charts menu, users can create 5 different charts for wide application of use cases. The charts are Min/Max, Income/Expense, Butterfly and 2 types of Bullet Charts.

All visualizations remain dynamic and can be shared with other users or in PowerPoint.

Create dynamic Heat Maps in Excel.

Create dynamic Heat Maps in Excel.

From the Pine BI Heat Map menu, users can create 2 different types of heat maps – sequential or diverging. Simply select the data you want to create the heat map on and choose the best suitable one.

All visualizations remain dynamic and can be shared with other users or in PowerPoint.

Create dynamic Data Cards in Excel.

Create dynamic Data Cards in Excel.

From the Pine BI Cards menu, users can create 2 different types of cards.

All visualizations remain dynamic and can be shared with other users or in PowerPoint.