Macros - Chart 

Page / - last modified by Sascha Hoppe on 2023/07/06 10:42 

Chart 
last modified by Sascha Hoppe
on 2023/07/06 10:42

Table of Contents
Pie Chart
Example 1
Example 2
Bar Chart
Time Series Chart

•	Pie Chart
•	Example 1
•	Example 2
•	Bar Chart
•	Time Series Chart
Chart Macro displays graphical charts generated from miscellaneous data sources. Learn more
Pie Chart
Example 1
•	Example 
•	Source 

{{chart type="pie" source="inline" params="range:B2-D5;series:columns;" title="Pie Chart" width="320" height="240"}}
|=|=X|=Y|=Z
|Q1|1.2|3.4|1.3
|Q2|4.5|3.4|2.3
|Q3|1.2|4.5|9.0
|Q4|3.4|1.2|1.2
{{/chart}}

Example 2
•	Example 
•	Source 

{{chart type="pie" source="inline" params="range:B2-D5;series:columns;colors:d9534f,f0ad4e,337ab7,5cb85c;backgroundColor:FFFFFF;" title="Pie Chart"}}
|=|=X|=Y|=Z
|Chrome|32|56|7
|Firefox|45|12|9
|Safari|12|45|0
|IE|6|46|2
{{/chart}}

Bar Chart
•	Example 
•	Source 

{{chart type="bar" source="inline" params="range:B2-D5;series:columns;colors:C3E3F7,1D9FF5,015891,012A45;backgroundColor:FFFFFF;" title="Bar Chart"}}
|=|=New Visitors|=Returning Visitors|=All Visitors
|January|1.2|3.4|1.3
|February|4.5|3.4|2.3
|March|1.2|4.5|9.0
|April|3.4|1.2|1.2
{{/chart}}

Time Series Chart
•	Example 
•	Source 

{{chart type="xy_line_and_shape" params="range:B2-C19;dataset:timetable_xy;domain_axis_type:date;domain_axis_date_format:MMM-yyyy;date_format:yyyy-MM;time_period:month;range_axis_lower:100;range_axis_upper:190" title="Time Series Chart"}}
|=|=Series1|=Series2
|2001-2|181.8|129.6
|2001-3|167.3|123.2
|2001-4|153.8|117.2
|2001-5|167.6|124.1
|2001-6|158.8|122.6
|2001-7|148.3|119.2
|2001-8|153.9|116.5
|2001-9|142.7|112.7
|2001-10|123.2|101.5
|2001-11|131.8|106.1
|2001-12|139.6|110.3
|2002-1|142.9|111.7
|2002-2|138.7|111.0
|2002-3|137.3|109.6
|2002-4|143.9|113.2
|2002-5|139.8|111.6
|2002-6|137.0|108.8
|2002-7|132.8|101.6
{{/chart}}