<div>
You mention formatting a graph in your question; I assume you mean on the axis.<br />
<br />
You can right click on the axis and choose Format Axis.<br />
<br />
The format options will appear on the Right Hand side of the screen. Midway down the screen there is an option for &quot;Display units&quot;, choose &quot;Thousands&quot; from the drop down. Untick the &quot;Show Display units label on chart&quot; otherwise the word &quot;Thousands&quot; appears next to the Axis.<br />
<br />
Further down you can then expand the Number options and choose Custom formats. If you choose a Standard format to begin with, eg accounting and include Symbol (I chose &quot;€ English (Ireland)&quot; to get correct symbol). Then you can tweak the format in the &quot;Format code&quot; box just below. I have used:<br />
<br />
_([$€-1809]* #,##0_)&quot;k&quot;;_([$€-1809]* (#,##0)&quot;k&quot;;_([$€-1809]* &quot;-&quot;_);_(@_)<br />
<br />
Thanks<br />
Rob H
</div>


You mention formatting a graph in your question; I assume you mean on the axis.

You can right click on the axis and choose Format Axis.

The format options will appear on the Right Hand side of the screen. Midway down the screen there is an option for "Display units", choose "Thousands" from the drop down. Untick the "Show Display units label on chart" otherwise the word "Thousands" appears next to the Axis.

Further down you can then expand the Number options and choose Custom formats. If you choose a Standard format to begin with, eg accounting and include Symbol (I chose "€ English (Ireland)" to get correct symbol). Then you can tweak the format in the "Format code" box just below. I have used:

_([$€-1809]* #,##0_)"k";_([$€-1809]* (#,##0)"k";_([$€-1809]* "-"_);_(@_)

Thanks
Rob H

<div>
<div class="content wysiwyg-content">
Hi, i would like to custom format my graph as follows<br />
<br />
80,000 €80k<br />
<br />
What is the custom format for this?<br />
<br />
Thanks
</div>
</div>


Hi, i would like to custom format my graph as follows

80,000 €80k

What is the custom format for this?

Thanks

Excel graph format

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.