# How to format pie chart values with a dot separator for thousands and comma for decimal?

**URL:** <https://community.plotly.com/t/how-to-format-pie-chart-values-with-a-dot-separator-for-thousands-and-comma-for-decimal/74391>\
**Category:** 📊 Plotly Python\
**Tags:** question\
**Created:** [April 13, 2023, 10:13am UTC](https://community.plotly.com/t/how-to-format-pie-chart-values-with-a-dot-separator-for-thousands-and-comma-for-decimal/74391 "2023-04-13T10:13:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dataturnsmeon](https://avatars.discourse-cdn.com/v4/letter/d/4af34b/32.png) [@dataturnsmeon](https://community.plotly.com/u/dataturnsmeon)\
**Post date:** [April 13, 2023, 10:13am UTC](https://community.plotly.com/t/how-to-format-pie-chart-values-with-a-dot-separator-for-thousands-and-comma-for-decimal/74391/1 "2023-04-13T10:13:11Z")

</div>

How can I display the pie chart values in the below format:  
12345678 → 12.345.678

---

<div class="post-metadata">

**Author:** ![AIMPED](https://sea2.discourse-cdn.com/flex024/user_avatar/community.plotly.com/aimped/32/21758_2.png) [@AIMPED](https://community.plotly.com/u/AIMPED)\
**Post date:** [April 13, 2023, 10:40am UTC](https://community.plotly.com/t/how-to-format-pie-chart-values-with-a-dot-separator-for-thousands-and-comma-for-decimal/74391/2 "2023-04-13T10:40:00Z")

</div>

Hi @dataturnsmeon the format is based on [d3-format](https://github.com/d3/d3-format)

This post is quite helpful // EDITED: for dates//:

> [@How to make the messy date ticks organized](https://community.plotly.com/t/how-to-make-the-messy-date-ticks-organized/7477/3):
>
> @MapleYU For Dates, Plotly accepts two things: Strings that are formatted like YYYY-MM-DD, e.g. '2015-01-01' (No other format is accepted) Datetime objects If the x-axis data is in one of those two forms, then Plotly will automatically use a date axis which will format your axes correctly. In your example, your date strings are formatted as YYYY/MM/DD and so Plotly is treating your axes as categorical strings instead of nicely formatted as spaced dates. Then, you can format the date axes u…

---

<div class="post-metadata">

**Author:** ![dataturnsmeon](https://avatars.discourse-cdn.com/v4/letter/d/4af34b/32.png) [@dataturnsmeon](https://community.plotly.com/u/dataturnsmeon)\
**Post date:** [April 13, 2023, 10:59am UTC](https://community.plotly.com/t/how-to-format-pie-chart-values-with-a-dot-separator-for-thousands-and-comma-for-decimal/74391/3 "2023-04-13T10:59:52Z")

</div>

Hi @AIMPED  
That post mentions only about date formatting and nothing about number formatting.

---

<div class="post-metadata">

**Author:** ![AIMPED](https://sea2.discourse-cdn.com/flex024/user_avatar/community.plotly.com/aimped/32/21758_2.png) [@AIMPED](https://community.plotly.com/u/AIMPED)\
**Post date:** [April 13, 2023, 11:06am UTC](https://community.plotly.com/t/how-to-format-pie-chart-values-with-a-dot-separator-for-thousands-and-comma-for-decimal/74391/4 "2023-04-13T11:06:01Z")

</div>

True, sorry for that. The d-3 formatting should work however.