Replies: 2 comments
-
Thanks for your feedback. This library only support label position in "Best Fit", I'll consider add support for change this setting later. |
Beta Was this translation helpful? Give feedback.
0 replies
-
This library now support set the data labels position for chart (#1755), please upgrade to the master branch code, and this feature will be released in the next version. Now you can set the data labels position like this: package main
import (
"fmt"
"github.com/xuri/excelize/v2"
)
func main() {
f := excelize.NewFile()
defer func() {
if err := f.Close(); err != nil {
fmt.Println(err)
}
}()
for idx, row := range [][]interface{}{
{"Apple", "Orange", "Pear"},
{2, 3, 3},
} {
cell, err := excelize.CoordinatesToCellName(1, idx+1)
if err != nil {
fmt.Println(err)
return
}
if err := f.SetSheetRow("Sheet1", cell, &row); err != nil {
fmt.Println(err)
return
}
}
if err := f.AddChart("Sheet1", "E1", &excelize.Chart{
Type: excelize.Pie,
Series: []excelize.ChartSeries{
{
Name: "Amount",
Categories: "Sheet1!$A$1:$C$1",
Values: "Sheet1!$A$2:$C$2",
DataLabelPosition: excelize.ChartDataLabelsPositionOutsideEnd,
},
},
Format: excelize.GraphicOptions{
OffsetX: 15,
OffsetY: 10,
},
Title: []excelize.RichTextRun{
{
Text: "Fruit Pie Chart",
},
},
PlotArea: excelize.ChartPlotArea{
ShowPercent: true,
},
}); err != nil {
fmt.Println(err)
return
}
// Save workbook
if err := f.SaveAs("Book1.xlsx"); err != nil {
fmt.Println(err)
}
} |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
current code
current effect
![image](https://private-user-images.githubusercontent.com/32082618/278527585-cbac0dda-9ab9-42c9-afd4-1ddedbbc7cd2.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjA1MjQ5NzUsIm5iZiI6MTcyMDUyNDY3NSwicGF0aCI6Ii8zMjA4MjYxOC8yNzg1Mjc1ODUtY2JhYzBkZGEtOWFiOS00MmM5LWFmZDQtMWRkZWRiYmM3Y2QyLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA3MDklMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNzA5VDExMzExNVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWRmY2E3ZTdlMmY3NTYwODlkOWY3YTc0ZDc0MzBjYjlhMDBiYTUwZGRkYmEyZjA0YTJlNjk1YmVhYzlkYzBhYWUmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.EWUv41FIFECZcRfKIolNp0ajo2rbw7R5qa7JB_vAoyg)
the effect i want
![image](https://private-user-images.githubusercontent.com/32082618/278527824-d312957c-917d-463f-bb3f-aa00eee4f472.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjA1MjQ5NzUsIm5iZiI6MTcyMDUyNDY3NSwicGF0aCI6Ii8zMjA4MjYxOC8yNzg1Mjc4MjQtZDMxMjk1N2MtOTE3ZC00NjNmLWJiM2YtYWEwMGVlZTRmNDcyLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA3MDklMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNzA5VDExMzExNVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTAxM2QwODY2NmY5NjVlZjQ2NTYzNGI4M2I1MzA2NjMwNDM4ZGY4YjZkZWY2MjJmNmUzYWMyNjZmMWUxOTViYmMmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.bAe3lNh7KUBuWeJNqRDd1GZiyE8efvKcP7lQmW0S5MY)
Beta Was this translation helpful? Give feedback.
All reactions