Loading...

Skip to main content

Charts

Spreadsheets help charts from the jquery.sheet interface

Chart Type	Example	Chart	Data	Month	Year
Vertical Bar	"=BARCHART(D2:D13)	List Spreadsheets Edit Parse Export Graph Edit Cell Set Reference Row Merge Un-Merge Add Row Add Multi-Rows Delete Row Insert Row Before Insert Row After Column Add Column Add Multi-Columns Delete Column Insert Column Before Insert Column After Fill Down Fill Up Sheet Add Spreadsheet Delete Spreadsheet Refresh calculations Title Find Get Cell Range Wrap Cell Range SUM() CEILING() COUNT() MAX() MIN() Undo Redo Toggle State View Function Reference Usage Example: =SUM(SUM(A1:B1) + SUM(D7)) =(TRUE(N(A1)) \|\| FALSE(N(B1))) ABS() AVG(), AVERAGE() CEILING() COUNT() DAYSFROM() DOLLAR() FALSE() FIXED() FLOOR() INT() MAX() MIN() N() NOW() PI() POWER(x, y) RAND(), RND() ROUND() SUM() TODAY() TRUE() VALUE() Toggle Full Screen Style Bold Italics Underline Strikethrough Left Center Right Uppercase Capitalize Lowercase Top Middle Bottom Font Size + Font Size - Related content More content and functionality (left side) doc.tiki.org Get Started Home All the documentation Troubleshooting Tutorials / HowTo Tiki New in version... Tiki 26.x Tiki 25.x Tiki 24.x LTS Tiki 24.x from Tiki 21.x Tiki 23.x Tiki 22.x Tiki 21.x LTS Tiki 21.x from Tiki 18.x Tiki 20.x Tiki 19.x Tiki 18.x LTS Tiki 18.x from Tiki 15.x Tiki 17.x Tiki 16.x Tiki 15.x LTS Tiki 15.x from Tiki 12.x Tiki 14.x Tiki 13.x Tiki 12.x LTS Tiki 12.x from Tiki 9.x Tiki 11.x Tiki 10.x Tiki 9.x LTS Tiki 8.x Tiki 7.x Tiki 6.x LTS Tiki 5.x Tiki 4.x Tiki 3.x LTS Tiki 2.x Tiki Reference Guide Tiki Installation Guide Admin Guide Tiki Administrator Guide Features Articles Config Article Details Article Generator Banners Banner User Banner Admin Blog Blog Config Blog Ref Calendar Admin Js Calendar Microformats Category Admin Category Transitions Categories Details Comment Admin Comment Moderation Content Templates Directory Admin Directory Details Dynamic Content Dynamic Content Admin File gallery admin File Gallery Config Batch Upload elFinder Forum Admin Forum Details Forum and Mailing List Synchronization Integrator Integrator User Integrator Admin Integrator Details Intrusion Detection System Live Support Live Support Admin Live Support Details Maps Maps Admin Maps Admin Gmap Gmap Details Menu Tutorial - HowTo Create Menus Newsletters Newsletter Admin Newsletter Details Newsletter Article Clipping Payment Community Currencies Feeds User RSS Admin RSS Feeds Details HTML Feed Slideshow Admin Slideshow Details Surveys Survey Admin Survey Details Tracker User Tracker Details Creating a Tracker Adding fields to a tracker How to change tracker field types Adding items to a tracker Tracker Field Validation Tracker Field Rules Searching tracker items User Tracker Group Tracker Pretty Tracker Pretty Tracker in a Wiki Page Linking trackers Export trackers Tracker Inline edit Import Trackers Tracker Synchronization Tracker Admin Improve Tracker Forms System Trackers Wiki Wiki Config Smileys AutoLinks Auto TOC Link Cache External Wikis Structures Structure Admin Structure Details Raw page display Slideshow HTML Pages History Wiki Details Wiki Inline Editing Redirect to similar wiki page Tell a Friend Wizards Profiles Wizard Admin Wizard Changes Wizard User Wizard - Set up the User Details screen Other Deliberation Addons Data Channels Local Profiles Revision approval, Flagged Revisions Communication Center User Levels Rating Share Workspace Workspace UI Namespaces Zotero PluginActivityStream Docs Ajax Live preview Semantic Links Semantic Admin WebDAV WebDAV access to Wiki Pages SCORM User - group - perms Users Group Transitions Permissions Banning Custom Home Contribution Admin Token Access Contribution Score Admin Score Details System Preference Filters ModSecurity Robots Exclusion Protocol Initial Configuration Tiki Importer MediaWiki Importer WordPress importer Stats Admin Compression External Authentication OpenID Admin DSN Content Authentication Link Cache Cookie Phpinfo Server Check Permission Check System Admin Logs Stats Security Admin Profiles Interoperability Referer Stats Mobile Batch Cron Job to Rebuild Search Index Web Services Reports Metrics Dashboard System Configuration Customize Import-Export htaccess php.ini Search Admin Search and List from Unified Index Rebuild Unified Index Search Details Search Stats Referrer Search Highlighting Search and replace Mail Mail notifications Mail Queue Mail-in Daily Reports Group Watches Groupmail Contact us Plugins Plugin Alias Plugin Security Plugin Approval i18n Admin Multilingual Module Multilingual trackers Multilingual Menu Character Encoding Multilingual Wiki Interface translation Interactive Translation Machine Translation Multilingual Article Multilingual Structures Multilingual categories Multilingual tags Editing Wysiwyg Editor Admin Syntax Highlighter Toolbar Tuning Tiki Design Edit Templates Edit CSS Theme Control Theme Generator Themes Smarty Templates Theme Layout Schema Customizing Themes Template tricks ViewerJS Hacking Code Performance Debugger Console TikiTests MinifiedScripts Content delivery network Amazon CloudFront ToolBox Multiplatform Tools Eclipse Linux tools Windows tools Mac Tools User Guide Tiki User Guide All Features Using Wiki Pages Forum User Article User Shoutbox User Blog User Using Content templates File Gallery User File Gallery for Images Directory User FAQ User Quiz User Spreadsheet Spreadsheet Functionality Spreadsheet Interface Spreadsheet Graphics and Charts Spreadsheet jq Survey User Newsletter User Stats User Calendar User Category User Comment User Live Support User Maps User Geolocation Gmap User Using Friendship Network Draw Timesheet Notepad Contacts Task User Calendar User Encryption User Menu User Modules API Internet of Things usage Trackers Creating a Tracker Adding fields to a tracker Action Tracker Field Articles Tracker Field Attachment Field Auto-Increment Field Category Tracker Field Checkbox Tracker Field Computed Tracker Field Currency Amount Tracker Field Date Tracker Fields Drop Down - Radio Tracker Field Duration Tracker field Dynamic items list Email Tracker Field Email folders Tracker Field Files Tracker Field Geographic feature Tracker Field Google Maps Tracker Field Heading Tracker Field Icon Tracker Field Image Tracker Field In Group Field Items List and Item Link Tracker Fields Kaltura Tracker Field Language Tracker Field LDAP Tracker Field Location Tracker Field Mathematical Calculation Tracker Field Multiselect Tracker Field Numeric Tracker Field Rating Tracker Field Relations Tracker Field Selector Tracker Fields Country Selector Group selector IP selector Page selector User selector Show.t.o Tracker Field Stars Field Static Text Tracker Field Subscription Tracker Field System Tracker Field Tags Tracker Field Textarea Tracker Field Tiki Manager Tracker Field URL Tracker Field User Groups User Preference Field Webservice tracker field Wiki page tracker field Adding items to a tracker How to change tracker field types Linking trackers Multilingual trackers Searching tracker items Viewing Tracker Results Export trackers Terms and Conditions Accounting MyAccount User Preferences Inter-User Messages Gmap User Bookmarks Watch User Page My Account top page Karma Score vs Karma User Action log Search User Mobile Tiki User User Wizard Must Reads Object Maintainers and Freshness 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 Articles and Submissions Backlinks Banners Batch BigBlueButton audio/video/chat/screensharing Blog Bookmark Browser Compatibility Link Cache Calendar Category Chat Clean URLs Comments Communication Center Compression (gzip) Contacts (Address Book) Contact us Content Templates Contribution Cookie Copyright Credit 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 Draw 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) Image Gallery Import-Export Install Integrator Interoperability Inter-User Messages InterTiki Kaltura video management Karma Live Support Login Logs (system & action) Look and Feel Mail-in Map with Mapserver Menu Meta Elements Mobile Tiki and Voice Tiki 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 Shadowbox Shadow Layers Share Shopping cart Shoutbox Slideshow Smiley Social Networks Spam protection (Anti-bot CATPCHA) Spellcheck Spreadsheet Stats Surveys Tags Task Tell a Friend, alert + Social Bookmarking TikiTests Theme CSS & Smarty Tiki Manager Trackers Transitions User Administration including registration and banning User Files User Menu Watch WebDAV Webmail Web Services Wiki History, page rename, etc Wiki Syntax Wiki structure (book and table of content) Workspace WSOD WYSIWYCA WYSIWYG XMLRPC Latest Changes PluginPiwik PluginImg Watch PluginList display control block PluginList format control block PluginList output control block PluginList filter control block PluginList pagination or list control block PluginList PluginLastMod ...more Featured Links Tiki Video Tutorials Tiki for Smarties (beginner's guide) Tiki Essentials (advanced) Tiki Newsletter Delivered fresh to your email inbox! Don't miss major announcements and other news! Site information, links, etc. About Tiki News Download Demo Features Tiki Association Contact Tiki Donation Support Forums Documentation Mailing lists FAQs Consultants Community Model Join Tiki Feature request / Bug report Featured Tikis Events Videos Documentation Basics Installation guide Configuration Features Tutorials Become an author Development The 3 rules Commit access Get the code Legal Terms of Service Privacy Policy Tiki Project Sites Community Development Documentation Themes Profiles Security Networks Twitter Facebook LinkedIn Open Hub YouTube Tiki® and TikiWiki® are registered trademarks of the Tiki Software Community Association. ⌅ [ Execution time: 0.10 secs ] [ Memory usage: 6.57MB ] [ Queries: 103 in 0.02 secs ] Git information: 28.x:55b4c3a0 from Wed 14 May, 2025 05:16 GMT-0000 Site identity, navigation, etc. At Tiki.org : Project Software Try Tiki Get Tiki Help Get Involved News Featured Tikis Register! Docs Documentation Tiki Wiki CMS Groupware Username Password CapsLock is on. Remember me (for 1 week) Username Password CapsLock is on. Remember me (for 1 week)