Changes for page Charting Samples
Last modified by Silvano Buback on 2018/02/26 16:20
Change comment:
Rollback to version 4.3
Summary
-
Page properties (3 modified, 0 added, 0 removed)
Details
- Page properties
-
- Author
-
... ... @@ -1,1 +1,1 @@ 1 -xwiki:XWiki. snbuback1 +xwiki:XWiki.VincentMassol - Syntax
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki 2.11 +XWiki 1.0 - Content
-
... ... @@ -1,16 +1,18 @@ 1 - =Charting Samples=1 +1 Charting Samples 2 2 3 - {{tocstart=""depth=""numbered=""/}}3 +#toc("" "" "") 4 4 5 - ==Chart Types==5 +1.1 Chart Types 6 6 7 - ===Pie Charts===7 +1.1.1 Pie Charts 8 8 9 -|=Category|=Sum 10 -|Category 1|80 11 -|Category 2|50 12 -|Category 3|70 13 -|Total|= sum(B2:B4) 9 +{table} 10 +Category | Sum 11 +Category 1 | 80 12 +Category 2 | 50 13 +Category 3 | 70 14 +Total | = sum(B2:B4) 15 +{table} 14 14 15 15 {chart:source=type:table;range:A1-B4|type=pie|title=pie (default)} 16 16 ... ... @@ -18,14 +18,16 @@ 18 18 19 19 {chart:source=type:table;range:A1-B4|type=pie|renderer=ring|title=pie (ring)} 20 20 21 - ===Bar Charts===23 +1.1.1 Bar Charts 22 22 23 -| |= |=First|=Second|=Third 24 -|Category 1|1.0|5.0|4.0 25 -|Category 2|4.0|7.0|6.0 26 -|Category 3|3.0|6.0|2.0 27 -|Category 4|5.0|8.0|3.0 28 -|Category 5|5.0|4.0|6.0 25 +{table} 26 + | First | Second | Third 27 +Category 1 | 1.0 | 5.0 | 4.0 28 +Category 2 | 4.0 | 7.0 | 6.0 29 +Category 3 | 3.0 | 6.0 | 2.0 30 +Category 4 | 5.0 | 8.0 | 3.0 31 +Category 5 | 5.0 | 4.0 | 6.0 32 +{table} 29 29 30 30 {chart:source=type:table;table_number:1|type=bar|width=600|title=bar (default)} 31 31 ... ... @@ -43,12 +43,14 @@ 43 43 44 44 {chart:source=type:table;table_number:1|type=bar|renderer=grouped_stacked_bar|width=600|title=bar (grouped_stacked_bar) |series_colors=red:255;green:0;blue:0;alpha:100,red:0;green:0;blue:255;alpha:100,red:0;green:255;blue:0;alpha:100} 45 45 46 -| |= |=First|=Second|=Third 47 -|1|1.0|5.0|4.0 48 -|2|4.0|7.0|6.0 49 -|3|3.0|6.0|2.0 50 -|4|5.0|8.0|3.0 51 -|6|5.0|4.0|6.0 50 +{table} 51 + | First | Second | Third 52 +1 | 1.0 | 5.0 | 4.0 53 +2 | 4.0 | 7.0 | 6.0 54 +3 | 3.0 | 6.0 | 2.0 55 +4 | 5.0 | 8.0 | 3.0 56 +6 | 5.0 | 4.0 | 6.0 57 +{table} 52 52 53 53 {chart:source=type:table;table_number:2|type=bar|renderer=xy_bar|width=500|title=bar (xy_bar) |series_colors=red:255;green:0;blue:0;alpha:100,red:0;green:0;blue:255;alpha:100,red:0;green:255;blue:0;alpha:100|} 54 54 ... ... @@ -56,12 +56,14 @@ 56 56 57 57 {chart:source=type:table;table_number:2|type=bar|renderer=xy_stacked_bar|width=500|title=bar (xy_stacked_bar)} 58 58 59 - ===Line Charts===65 +1.1.1 Line Charts 60 60 61 -|= |=1.0|=2.0|=3.0|=4.0|=5.0|=6.0|=9.0 62 -|First|1.0|4.0|3.0|5.0|5.0|7.0|8.0 63 -|Second|5.0|7.0|6.0|8.0|4.0|4.0|2.0 64 -|Third|3.0|4.0|4.0|3.0|2.0|3.0|6.0 67 +{table} 68 + | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | 6.0 | 9.0 69 +First | 1.0 | 4.0 | 3.0 | 5.0 | 5.0 | 7.0 | 8.0 70 +Second | 5.0 | 7.0 | 6.0 | 8.0 | 4.0 | 4.0 | 2.0 71 +Third | 3.0 | 4.0 | 4.0 | 3.0 | 2.0 | 3.0 | 6.0 72 +{table} 65 65 66 66 {chart:source=type:table;table_number:3|series=rows|type=line|renderer=xy_line_and_shape|title=line (xy_line_and_shape, default)|height=400|width=600} 67 67 ... ... @@ -75,7 +75,7 @@ 75 75 76 76 {chart:source=type:table;table_number:3|series=rows|type=line|renderer=step|renderer_stroke=width:2|title=line (step)|height=400|width=600} 77 77 78 - ===Area Charts===86 +1.1.1 Area Charts 79 79 80 80 {chart:source=type:table;table_number:3|series=rows|type=area|renderer=xy_area|title=area (xy_area, default)|domain_axis_auto_range_includes_zero=false|domain_axis_lower_margin=0|domain_axis_upper_margin=0|height=400|width=600 |series_colors=red:255;green:0;blue:0;alpha:100,red:0;green:0;blue:255;alpha:100,red:0;green:255;blue:0;alpha:100} 81 81 ... ... @@ -83,27 +83,29 @@ 83 83 84 84 {chart:source=type:table;table_number:3|series=rows|type=area|renderer=xy_step_area|title=area (xy_step_area)|domain_axis_auto_range_includes_zero=false|domain_axis_lower_margin=0|domain_axis_upper_margin=0|height=400|width=600 |series_colors=red:255;green:0;blue:0;alpha:100,red:0;green:0;blue:255;alpha:100,red:0;green:255;blue:0;alpha:100} 85 85 86 - ===Time Charts===94 +1.1.1 Time Charts 87 87 88 -|= |=Series1|=Series2 89 -|2001-2|181.8|129.6 90 -|2001-3|167.3|123.2 91 -|2001-4|153.8|117.2 92 -|2001-5|167.6|124.1 93 -|2001-6|158.8|122.6 94 -|2001-7|148.3|119.2 95 -|2001-8|153.9|116.5 96 -|2001-9|142.7|112.7 97 -|2001-10|123.2|101.5 98 -|2001-11|131.8|106.1 99 -|2001-12|139.6|110.3 100 -|2002-1|142.9|111.7 101 -|2002-2|138.7|111.0 102 -|2002-3|137.3|109.6 103 -|2002-4|143.9|113.2 104 -|2002-5|139.8|111.6 105 -|2002-6|137.0|108.8 106 -|2002-7|132.8|101.6 96 +{table} 97 + | Series1 | Series2 98 +2001-2 | 181.8 | 129.6 99 +2001-3 | 167.3 | 123.2 100 +2001-4 | 153.8 | 117.2 101 +2001-5 | 167.6 | 124.1 102 +2001-6 | 158.8 | 122.6 103 +2001-7 | 148.3 | 119.2 104 +2001-8 | 153.9 | 116.5 105 +2001-9 | 142.7 | 112.7 106 +2001-10 | 123.2 | 101.5 107 +2001-11 | 131.8 | 106.1 108 +2001-12 | 139.6 | 110.3 109 +2002-1 | 142.9 | 111.7 110 +2002-2 | 138.7 | 111.0 111 +2002-3 | 137.3 | 109.6 112 +2002-4 | 143.9 | 113.2 113 +2002-5 | 139.8 | 111.6 114 +2002-6 | 137.0 | 108.8 115 +2002-7 | 132.8 | 101.6 116 +{table} 107 107 108 108 {chart:source=type:table;table_number:4|type=time|title=time (default)|date_format=type:custom;pattern:yyyy-MM|width=500} 109 109 ... ... @@ -113,35 +113,39 @@ 113 113 114 114 {chart:source=type:table;table_number:4|type=time|renderer=xy_step|title=time (xy_step)|date_format=type:custom;pattern:yyyy-MM|width=500} 115 115 116 - ==Customizations==126 +1.1 Customizations 117 117 118 -Sorry for my lack of artistic skills 128 +Sorry for my lack of artistic skills ;) 119 119 120 - ===Borders===130 +1.1.1 Borders 121 121 122 -{chart:source=type:table;table_number:0;range:A1-B4;has_header_row:true;has_header_column:true| title=A pie in the sky|anti_alias=false|background_color=navy|plot_background_color=silver|plot_background_alpha=1.0|plot_foreground_alpha=0.7|plot_inserts=top:0;bottom:0;left:10;right:20|plot_outline_color=#FFFFFF|plot_outline_stroke=width:6|plot_zoom=3|title_position=bottom|title_color=red|title_background_color=#000080|title_font=name:Times New Roman;style:bold;size:32|title_horizontal_alignment=left|title_vertical_alignment=bottom|title_padding=right:10;bottom:20;left:30;top:40|type=pie|series=columns|width=500|height=400|border_visible=true|border_color=blue|border_stroke=width:5.57;cap:butt;join:bevel;miterlimit:0.94;dash:1.5,2.3,4.5;dash_phase:1.3} 132 +{chart:source=type:table;table_number:0;range:A1-B4;has_header_row:true;has_header_column:true| 133 +title=A pie in the sky|anti_alias=false|background_color=navy|plot_background_color=silver|plot_background_alpha=1.0|plot_foreground_alpha=0.7|plot_inserts=top:0;bottom:0;left:10;right:20|plot_outline_color=#FFFFFF|plot_outline_stroke=width:6|plot_zoom=3|title_position=bottom|title_color=red|title_background_color=#000080|title_font=name:Times New Roman;style:bold;size:32|title_horizontal_alignment=left|title_vertical_alignment=bottom|title_padding=right:10;bottom:20;left:30;top:40|type=pie|series=columns|width=500|height=400|border_visible=true|border_color=blue|border_stroke=width:5.57;cap:butt;join:bevel;miterlimit:0.94;dash:1.5,2.3,4.5;dash_phase:1.3} 123 123 124 - ===Legend===135 +1.1.1 Legend 125 125 126 126 {chart:type=line|renderer=line_and_shape|source=type:table;table_number:3;range:*;has_header_row:true;has_header_column:true|series=rows|width=600|height=350|legend_background_color=silver|legend_item_font=style:bold;size:16;name:Arial|legend_item_label_padding=left:10;right:0;top:0;bottom:0|legend_item_graphic_anchor=center|legend_item_graphic_edge=right|legend_item_graphic_location=top-left|legend_item_graphic_padding=top:5;left:10;right:0;bottom:0} 127 127 128 - ===Custom XYPlot===139 +1.1.1 Custom XYPlot 129 129 130 -{chart:type=line|source=type:table; table_number:3;range:*;has_header_row:true;has_header_column:true|series=rows|width=600|height=350|plot_orientation=vertical|plot_quadrant_origin=x:2.0;y:2.0|plot_quadrant_colors=red, blue, yellow, silver|axis_domain_gridline_visible=false|axis_range_gridline_visible=true|axis_range_gridline_color=silver|axis_range_gridline_stroke=width:1} 141 +{chart:type=line|source=type:table; 142 +table_number:3;range:*;has_header_row:true;has_header_column:true|series=rows|width=600|height=350|plot_orientation=vertical|plot_quadrant_origin=x:2.0;y:2.0|plot_quadrant_colors=red, blue, yellow, silver|axis_domain_gridline_visible=false|axis_range_gridline_visible=true|axis_range_gridline_color=silver|axis_range_gridline_stroke=width:1} 131 131 132 - ===Custom Renderer===144 +1.1.1 Custom Renderer 133 133 134 134 {chart:type=line|source=type:table;table_number:3;range:*;has_header_row:true;has_header_column:true|series=rows|width=600|height=350|renderer_color=blue|renderer_stroke=width:3|renderer_series_visible=true|renderer_item_label_visible=false|renderer_series_shapes=square,circle,diamond|renderer_shape=square} 135 135 136 136 {chart:type=bar|source=type:table;table_number:3|series=rows|width=600|height=400|renderer_fill_color=silver|renderer_outline_color=red:200;green:0;blue:0;alpha:100|renderer_outline_stroke=width:10 |renderer_series_visible=true|renderer_item_label_visible=true} 137 137 138 - ===Ignore Alpha===150 +1.1.1 Ignore Alpha 139 139 140 -|=column1|=column2|=column3 141 -|row1|1|2|3 142 -|row2|1.0|2.0|3.0 143 -|row3|1,0|2,0|3,0 144 -|row4|1px|2m|3 banannas 152 +{table} 153 +|column1|column2|column3 154 +row1|1|2|3 155 +row2|1.0|2.0|3.0 156 +row3|1,0|2,0|3,0 157 +row4|1px|2m|3 banannas 158 +{table} 145 145 146 146 {chart:type=bar|source=type:table;table_number:5;range:*;has_header_row:true;has_header_column:true;ignore_alpha:false;decimal_symbol:period|series=rows} 147 147 ... ... @@ -151,21 +151,24 @@ 151 151 152 152 {chart:type=bar|source=type:table;table_number:0;range:*;has_header_row:true;has_header_column:true;ignore_alpha:true;decimal_symbol:comma|series=rows|link_attributes=name:a chart|image_attributes=border:none} 153 153 154 - ===Custom Number Axis===168 +1.1.1 Custom Number Axis 155 155 156 156 {chart:type=line|source=type:table;table_number:3;range:*;has_header_row:true;has_header_column:true|series=rows|domain_axis_auto_range=true|domain_axis_auto_range_min_size=15|domain_axis_lower_margin=0.50|domain_axis_upper_margin=0.50|range_axis_auto_range=false|range_axis_lower_bound=2|range_axis_upper_bound=10|range_axis_auto_tick_unit=true|range_axis_vertical_tick_labels=true|domain_axis_range_type=positive|domain_axis_number_format_override=type:number;language:rum;country:RO} 157 157 158 158 {chart:type=line|source=type:table;table_number:3;range:*;has_header_row:true;has_header_column:true|series=rows|domain_axis_auto_range=false|domain_axis_auto_range=false|domain_axis_lower_bound=2.5|domain_axis_upper_bound=10|domain_axis_number_tick_unit=size:1.5|domain_axis_number_format_override=type:currency;language:ger;country:DE} 159 159 160 -=== Custom Category Axis === 161 161 162 -|= |=Category 1|=Category 2|=Category 3|=Category 4|=Category 5 6 7 8 9 5 6 7 8 9 5 6 7 8 9 163 -|First|1.0|4.0|3.0|5.0|5.0 164 -|Second|5.0|7.0|6.0|8.0|4.0 165 -|Third|4.0|3.0|2.0|3.0|6.0 175 +1.1.1 Custom Category Axis 166 166 177 +{table} 178 + | Category 1 | Category 2 | Category 3 | Category 4 | Category 5 6 7 8 9 5 6 7 8 9 5 6 7 8 9 179 +First | 1.0 | 4.0 | 3.0 | 5.0 | 5.0 180 +Second | 5.0 | 7.0 | 6.0 | 8.0 | 4.0 181 +Third | 4.0 | 3.0 | 2.0 | 3.0 | 6.0 182 +{table} 183 + 167 167 {chart:type=bar|source=type:table;table_number:6|series=rows|height=400|width=600|domain_axis_category_margin=0.1|domain_axis_label_positions=down_45|domain_axis_label_position_offset=20|domain_axis_maximum_label_lines=2|domain_axis_maximul_label_width_ratio=0.3} 168 168 169 - ===Time Series===186 +1.1.1 Time Series 170 170 171 171 {chart:type=time|source=type:table;table_number:4;ignore_alpha:true|date_format=type:custom;pattern:yyyy-MM|height=400|width=700|domain_axis_date_format_override=type:date;style:short;language:rum;country:RO|domain_axis_lower_date=value:2001-6;type:custom;pattern:yyyy-MM|domain_axis_upper_date=value:2002-4;type:custom;pattern:yyyy-MM|domain_axis_date_tick_unit=unit:month;count:1|domain_axis_tick_mark_position:ende}