How to Add Rupee Symbol In Microsoft Excel 2010

In this article, you will learn on to show Indian Rupee symbol in chart.

 

Let us take an example to understand:

We have Sales Report that contains US states & quarterly sales.
 
img7
 
From the above data, we have made a chart to show the quarterly Sales for each state.
 
img1
 
Here, we want to show the sales in millions with Indian Rupee symbol.

Right click on Vertical Value Axis & click on Format Axis
 
img2
 
The Format Axis options will be displayed
 
img3
 
Select Number option
 
img4
 
Select the Category as Custom; in Format Code, paste the following code

[>999999]?#,,” M”;[>999]?#,”K”;?#
 
img5
 
Click on Add. This will show the Indian Rupee symbol in the chart. Refer below shown snapshot
 
img6
 
In this way, you can show Indian Rupee symbol in the chart.
 
 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube