Pandas - Formatting Column chart label

Question

I am trying to create a column chart using Pandas.

I have a DataFrame in the below format.

Week, Percent_Sold
1,13
2,15
3,44

I am trying to get a column chart using the below code:

chart = workbook.add_chart({'type': 'column'})
chart.add_series({'name': 'Sales Percent', 'categories': f'=\'sales\'!$A$11:$A$13',
                                     'values': f'=\'sales\'!$B$11:$B$13',
                                     'data_labels': {'value': True, 'num_format': '0%'}})

The above works well, however I see the numbers in chart get converted from 13 to 1300% but rather I am trying to display 13% in the chart. How could I modify the add_series method to fix this.

pedro_bb7 · Accepted Answer · 2019-12-02 07:09:19Z

1

If you want 13.00% to be displayed: 'num_format':'0.00##\%'

Else if you want 13% (without any decimals), then: 'num_format':'##\%'

Got answer from this topic: Percentage format multiplies cell value by 100

PS: It's more related to xlsxwriter than pandas

edited Dec 2, 2019 at 7:09

answered Dec 2, 2019 at 5:19

pedro_bb7

2,1213 gold badges18 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

scott martin Over a year ago

I am able to display the number with the formatting %. I am trying to add the % symbol next to the number, doing so changes the number from 13 to 1300%

scott martin Over a year ago

it fails as it throws an error name 'f' is not defined

Collectives™ on Stack Overflow

Pandas - Formatting Column chart label

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest