summaryrefslogtreecommitdiff
path: root/chart.go
diff options
context:
space:
mode:
Diffstat (limited to 'chart.go')
-rw-r--r--chart.go148
1 files changed, 141 insertions, 7 deletions
diff --git a/chart.go b/chart.go
index bdb7f5b..9d44c50 100644
--- a/chart.go
+++ b/chart.go
@@ -514,8 +514,11 @@ func parseFormatChartSet(formatSet string) (*formatChart, error) {
// )
//
// func main() {
-// categories := map[string]string{"A2": "Small", "A3": "Normal", "A4": "Large", "B1": "Apple", "C1": "Orange", "D1": "Pear"}
-// values := map[string]int{"B2": 2, "C2": 3, "D2": 3, "B3": 5, "C3": 2, "D3": 4, "B4": 6, "C4": 7, "D4": 8}
+// categories := map[string]string{
+// "A2": "Small", "A3": "Normal", "A4": "Large",
+// "B1": "Apple", "C1": "Orange", "D1": "Pear"}
+// values := map[string]int{
+// "B2": 2, "C2": 3, "D2": 3, "B3": 5, "C3": 2, "D3": 4, "B4": 6, "C4": 7, "D4": 8}
// f := excelize.NewFile()
// for k, v := range categories {
// f.SetCellValue("Sheet1", k, v)
@@ -523,7 +526,54 @@ func parseFormatChartSet(formatSet string) (*formatChart, error) {
// for k, v := range values {
// f.SetCellValue("Sheet1", k, v)
// }
-// if err := f.AddChart("Sheet1", "E1", `{"type":"col3DClustered","series":[{"name":"Sheet1!$A$2","categories":"Sheet1!$B$1:$D$1","values":"Sheet1!$B$2:$D$2"},{"name":"Sheet1!$A$3","categories":"Sheet1!$B$1:$D$1","values":"Sheet1!$B$3:$D$3"},{"name":"Sheet1!$A$4","categories":"Sheet1!$B$1:$D$1","values":"Sheet1!$B$4:$D$4"}],"title":{"name":"Fruit 3D Clustered Column Chart"},"plotarea":{"show_bubble_size":true,"show_cat_name":false,"show_leader_lines":false,"show_percent":true,"show_series_name":true,"show_val":true},"show_blanks_as":"zero","x_axis":{"reverse_order":true},"y_axis":{"maximum":7.5,"minimum":0.5}}`); err != nil {
+// if err := f.AddChart("Sheet1", "E1", `{
+// "type": "col3DClustered",
+// "series": [
+// {
+// "name": "Sheet1!$A$2",
+// "categories": "Sheet1!$B$1:$D$1",
+// "values": "Sheet1!$B$2:$D$2"
+// },
+// {
+// "name": "Sheet1!$A$3",
+// "categories": "Sheet1!$B$1:$D$1",
+// "values": "Sheet1!$B$3:$D$3"
+// },
+// {
+// "name": "Sheet1!$A$4",
+// "categories": "Sheet1!$B$1:$D$1",
+// "values": "Sheet1!$B$4:$D$4"
+// }],
+// "title":
+// {
+// "name": "Fruit 3D Clustered Column Chart"
+// },
+// "legend":
+// {
+// "none": false,
+// "position": "bottom",
+// "show_legend_key": false
+// },
+// "plotarea":
+// {
+// "show_bubble_size": true,
+// "show_cat_name": false,
+// "show_leader_lines": false,
+// "show_percent": true,
+// "show_series_name": true,
+// "show_val": true
+// },
+// "show_blanks_as": "zero",
+// "x_axis":
+// {
+// "reverse_order": true
+// },
+// "y_axis":
+// {
+// "maximum": 7.5,
+// "minimum": 0.5
+// }
+// }`); err != nil {
// fmt.Println(err)
// return
// }
@@ -627,10 +677,13 @@ func parseFormatChartSet(formatSet string) (*formatChart, error) {
//
// Set properties of the chart legend. The options that can be set are:
//
+// none
// position
// show_legend_key
//
-// position: Set the position of the chart legend. The default legend position is right. The available positions are:
+// none: Specified if show the legend without overlapping the chart. The default value is 'false'.
+//
+// position: Set the position of the chart legend. The default legend position is right. This parameter only takes effect when 'none' is false. The available positions are:
//
// top
// bottom
@@ -728,8 +781,11 @@ func parseFormatChartSet(formatSet string) (*formatChart, error) {
// )
//
// func main() {
-// categories := map[string]string{"A2": "Small", "A3": "Normal", "A4": "Large", "B1": "Apple", "C1": "Orange", "D1": "Pear"}
-// values := map[string]int{"B2": 2, "C2": 3, "D2": 3, "B3": 5, "C3": 2, "D3": 4, "B4": 6, "C4": 7, "D4": 8}
+// categories := map[string]string{
+// "A2": "Small", "A3": "Normal", "A4": "Large",
+// "B1": "Apple", "C1": "Orange", "D1": "Pear"}
+// values := map[string]int{
+// "B2": 2, "C2": 3, "D2": 3, "B3": 5, "C3": 2, "D3": 4, "B4": 6, "C4": 7, "D4": 8}
// f := excelize.NewFile()
// for k, v := range categories {
// f.SetCellValue("Sheet1", k, v)
@@ -737,7 +793,85 @@ func parseFormatChartSet(formatSet string) (*formatChart, error) {
// for k, v := range values {
// f.SetCellValue("Sheet1", k, v)
// }
-// if err := f.AddChart("Sheet1", "E1", `{"type":"col","series":[{"name":"Sheet1!$A$2","categories":"","values":"Sheet1!$B$2:$D$2"},{"name":"Sheet1!$A$3","categories":"Sheet1!$B$1:$D$1","values":"Sheet1!$B$3:$D$3"}],"format":{"x_scale":1.0,"y_scale":1.0,"x_offset":15,"y_offset":10,"print_obj":true,"lock_aspect_ratio":false,"locked":false},"legend":{"position":"left","show_legend_key":false},"title":{"name":"Clustered Column - Line Chart"},"plotarea":{"show_bubble_size":true,"show_cat_name":false,"show_leader_lines":false,"show_percent":true,"show_series_name":true,"show_val":true}}`, `{"type":"line","series":[{"name":"Sheet1!$A$4","categories":"Sheet1!$B$1:$D$1","values":"Sheet1!$B$4:$D$4","marker":{"symbol":"none","size":10}}],"format":{"x_scale":1,"y_scale":1,"x_offset":15,"y_offset":10,"print_obj":true,"lock_aspect_ratio":false,"locked":false},"legend":{"position":"left","show_legend_key":false},"plotarea":{"show_bubble_size":true,"show_cat_name":false,"show_leader_lines":false,"show_percent":true,"show_series_name":true,"show_val":true}}`); err != nil {
+// if err := f.AddChart("Sheet1", "E1", `{
+// "type": "col",
+// "series": [
+// {
+// "name": "Sheet1!$A$2",
+// "categories": "",
+// "values": "Sheet1!$B$2:$D$2"
+// },
+// {
+// "name": "Sheet1!$A$3",
+// "categories": "Sheet1!$B$1:$D$1",
+// "values": "Sheet1!$B$3:$D$3"
+// }],
+// "format":
+// {
+// "x_scale": 1.0,
+// "y_scale": 1.0,
+// "x_offset": 15,
+// "y_offset": 10,
+// "print_obj": true,
+// "lock_aspect_ratio": false,
+// "locked": false
+// },
+// "title":
+// {
+// "name": "Clustered Column - Line Chart"
+// },
+// "legend":
+// {
+// "position": "left",
+// "show_legend_key": false
+// },
+// "plotarea":
+// {
+// "show_bubble_size": true,
+// "show_cat_name": false,
+// "show_leader_lines": false,
+// "show_percent": true,
+// "show_series_name": true,
+// "show_val": true
+// }
+// }`, `{
+// "type": "line",
+// "series": [
+// {
+// "name": "Sheet1!$A$4",
+// "categories": "Sheet1!$B$1:$D$1",
+// "values": "Sheet1!$B$4:$D$4",
+// "marker":
+// {
+// "symbol": "none",
+// "size": 10
+// }
+// }],
+// "format":
+// {
+// "x_scale": 1,
+// "y_scale": 1,
+// "x_offset": 15,
+// "y_offset": 10,
+// "print_obj": true,
+// "lock_aspect_ratio": false,
+// "locked": false
+// },
+// "legend":
+// {
+// "position": "right",
+// "show_legend_key": false
+// },
+// "plotarea":
+// {
+// "show_bubble_size": true,
+// "show_cat_name": false,
+// "show_leader_lines": false,
+// "show_percent": true,
+// "show_series_name": true,
+// "show_val": true
+// }
+// }`); err != nil {
// fmt.Println(err)
// return
// }
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-16 09:58:33 +0000