Loading...
 
Draw charts from your spreadsheets (Cached)

Spreadsheet Graphics and Charts



Graphics can be created using the Graph button in the spreadsheet view or from the sheet listing, which takes the user to tiki-graph_sheet.php?sheetId=1 (1 or the numeric id of that sheet). Two simple forms are presented to select the parameters of the graphic.

Select the Graphic Type and Output Format


Image
Fig. 1: First form



The radio buttons select the type of graphic to be generated. A first example will be made with the Pie Chart and a second one with Multibar. Multiline and Bar Stack use the same parameters as Bar Stack.

Multiple output formats are available. Depending on the installed extensions on the server, some elements might not be available. PDF and PostScript are printable format and require the paper size and orientation parameters. PNG and JPEG are images and require height and width parameters in pizels.

If the objective is to include the graphic in a wiki page, the selected format will only be used for the preview.



Parameters

Figure 2 presents the parameters entered to obtain a pie chart from the speadsheet and Figure 3 is the result obtained. The page is divided in three sections:
  1. Parameter form
  2. Spreadsheet
  3. Wiki Plug-in

The parameter form is used to select the elements that will be displayed in the graphic. All parameters under the series label are value ranges from the spreadsheet in A1:Z99 format or comma seperated list of elements (ex: Blue, ))LightBlue,LightGreen((). The color and style series require special values:

Color
  • Red
  • Green
  • Blue
  • Yellow
  • Orange
  • LightBlue
  • LightGreen

Style
  • Thin-LineStroke
  • Thin-FillStroke
  • Normal-LineStroke
  • Normal-FillStroke
  • Bold-LineStroke
  • Bold-FillStroke
  • Bolder-LineStroke
  • Bolder-FillStroke

The spreadsheet is available as a reference to select the ranges.

The wiki plug-in is updated as the parameters are changed in the form. The code displayed can be pasted in a wiki page to display the graphic. The plug-in does not consider the selected output format. Instead, it will automatically select the best format available. If possible, it will display an image and link to a printable format. Prefered image format is PNG and prefered printable format is PDF.

Pie Chart Parameters

The following table presents the different field of the form, what they are used for and the behavior if left empty.

Title Used as the title of the graphic No title
Label Caption in the legends No legend
Value Values used in the chart Required
Color Colors used for the elements Automatically selected
Style Change border type Normal-FillStroke


The amount of elements in every range must be the same.


Image
Fig. 2: Parameters for the pie chart.


Image
Fig. 3: Resulting pie chart.



Multibar Parameters

Figure 4 presents the parameters used to create the graphic in Figure 5. Note that different size parameters have been used to suite the large amount of data. Here is the table presenting the different parameters.

Title Title of the graphic No title
Independant Scale Determines if the graphic is vertical or horizontal
Horizontal Scale Location of the horizontal scale
Vertical Scale Location of the vertical scale
Label Caption of the different elements in the legend No legend
Color Colors used in the legend Automatically selected
Style Border type used Normal-FillStroke
X Independant scale range Required.
Y0  First dependant range Required.
Y1-Y4  Additional dependant range


The amount of elements in the Label, Color and Style ranges must be equal to the amount of Y ranges used. The amount of elements in the X range and all Y ranges must be the same.


Image
Fig. 4: Parameters for the multibar graphic


Image
Fig. 5: Resulting multibar graphic


Spreadsheet JQ Charts

Another option is to make the charts reusing the raphael.js charting library embedded in the jquery spreadsheet. See:
Chart Type Example Chart Data Month Year
Vertical Bar “=BARCHART(D2:D13)
Created with Raphaël4
Jan 2001
Horizontal Bar "=HBARCHART(D2:D13)
Created with Raphaël6
Feb 2002
Pie "=LINECHART(D2:D8, F2:F6)"
Created with Raphaël7.2
Mar 2003
Line “=PIECHART(D2:D8, E2:E8)”
Created with Raphaël 7.5 Apr 2004
8.2 May 2005
9.1 Jun 2006
14.1 Jul 2007
16 Aug 2008
17.9 Sep 2009
22 Oct 2010
30 Nov 2011
32 Dec 2012



doc.tiki.org


Bootstrap

AdminGuide

UserGuide

Keywords

Keywords serve as “hubs” for navigation within the Tiki documentation. They correspond to development keywords (bug reports and feature requests):

Accessibility (WAI and 508)
Accounting (7.x)
Articles and Submissions
Backlinks
Banners
Batch (6.x)
BigBlueButton audio/video/chat/screensharing (5.x)
Blog
Bookmark
Browser Compatibility
Link Cache
Calendar
Category
Chat
Clean URLs
Comments
Communication Center
Compression (gzip)
Contacts (Address Book)
Contact us
Content Templates
Contribution (2.x)
Cookie
Copyright
Credit (6.x)
Custom Home and Group Home Page
Date and Time
Debugger Console
Directory of hyperlinks
Documentation link from Tiki to doc.tiki.org (Help System)
Docs 8.x
Draw 7.x
Dynamic Content
Dynamic Variable
External Authentication
FAQ
Featured links
File Gallery
Forum
Friendship Network (Community)
Gmap Google maps
Groups
Hotword
HTML Page
i18n (Multilingual, l10n, Babelfish)
Image Gallery
Import-Export
Install
Integrator
Interoperability
Inter-User Messages
InterTiki
Kaltura video management (4.x)
Karma
Live Support
Login
Logs (system & action)
Look and Feel
Lost edit protection
Mail-in
Map with Mapserver
Menu
Meta Tags
Mobile Tiki and Voice Tiki
Mods
Module
MultiTiki
MyTiki
Newsletter
Notepad
Payment
Performance Speed / Load
Permissions
Platform independence (Linux-Apache, Windows/IIS, Mac, BSD)
Polls
Profiles
Profile Manager
Report
Toolbar
Quiz
Rating
Feeds
Score
Search engine optimization
Search
Search and Replace
Security
Semantic links (3.x)
Shadowbox
Shadow Layers
Share
Shopping cart
Shoutbox
Slideshow
Smiley
Social Networks
Spam protection (Anti-bot CATPCHA)
Spellcheck
Spreadsheet
Stats
Surveys
Tags (2.x)
Task
Tell a Friend, alert + Social Bookmarking
TikiTests (2.x)
Theme CSS & Smarty
Trackers
Transitions (5.x)
TRIM
User Administration including registration and banning
User Files
User Menu
Watch
WebHelp
WebDAV (5.x)
Webmail
Web Services
Wiki 3D
Wiki History, page rename, etc
Wiki Page Staging and Approval (2.x)
Wiki Plugin extends basic syntax
Wiki Syntax
Wiki structure (book and table of content)
Workspace
WSOD
WYSIWYCA
WYSIWYG (2.x)
XMLRPC


Tiki Newsletter

Delivered fresh to your email inbox!
Newsletter subscribe icon
Don't miss major announcements and other news!
Contribute to Tiki
Show php error messages