Pivot Charts By Toma Vajngerl www.collaboraoffjce.co C o l l a - - PowerPoint PPT Presentation
C o l l a b o r a P r o d u c t i v i t y Pivot Charts By Toma Vajngerl www.collaboraoffjce.co C o l l a b o r a P r o d u c t i v i t y m Pivot Charts Work sponsored by Nantes New feature added in
C
l a b
a P r
u c t i v i t y
www.collaboraoffjce.co m
C
l a b
a P r
u c t i v i t y
By Tomaž Vajngerl
C
l a b
a P r
u c t i v i t y
www.collaboraoffjce.com
Work sponsored by Nantes
New feature added in LibreOffjce 5.4
C
l a b
a P r
u c t i v i t y
www.collaboraoffjce.com
Pivot tables are used to extract informatjon from a (large) data set, pivot chart are then used to visualize the data. Chart using data from the pivot table...
C
l a b
a P r
u c t i v i t y
www.collaboraoffjce.com
C
l a b
a P r
u c t i v i t y
www.collaboraoffjce.com
Separate from “spreadsheet” data provider Takes pivot table data and maps it to the chart’s data sequences
C
l a b
a P r
u c t i v i t y
www.collaboraoffjce.com
data
C
l a b
a P r
u c t i v i t y
www.collaboraoffjce.com
C
l a b
a P r
u c t i v i t y
www.collaboraoffjce.com
C
l a b
a P r
u c t i v i t y
www.collaboraoffjce.com
To show the fjlter pop-up menu from pivot table Chart doesn’t have direct access to Calc so a bridge is needed
C
l a b
a P r
u c t i v i t y
www.collaboraoffjce.com
C
l a b
a P r
u c t i v i t y
www.collaboraoffjce.com
C
l a b
a P r
u c t i v i t y
www.collaboraoffjce.com
OOXML support Creatjon of pivot table and chart together – menu item
C
l a b
a P r
u c t i v i t y