Displaying Numbers in Thousands in a Chart in Microsoft Excel

In Microsoft Excel we can show numbers in hundreds, thousands, ten thousands & we will learn how to display the numbers in thousands in chart. We will use the Custom format cells option in Microsoft Excel to display the numbers in thousands in chart.

Charts are linked to data and, consequently, any change to the format of numbers in the data table will lead to a corresponding change in how the numbers are displayed in the chart.

Custom Format: -We can use Custom Number Format to display a Number in Million or Display it in some Color. It’s a tool from old version of excel when there was no Conditional Formatting option in Excel. All conditional options are performed by using Custom Number Format.

Let’s take an example to understand how we can display the numbers in thousands in chart:-

We have data in range A1:B11 where column A contains city name and column B contains populations. We prepared a chart to show the population. We need to show the population in thousands.

img1

To display the numbers in thousands, follow below given steps :-

  • Select the range B2:B11, and press the key Ctrl+1 on your keyboard.
  • Format Cells dialog box will appear.

img2

  • In the Number Tab, Click on Custom.
  • After clicking on the Custom, related options will get appear.
  • In the type box, write the format type #,##0, and Click on OK.

img3

  • The function will rounded in thousands.

img4

We can make numbers displaying in thousands in Chart. With little bit of modification in formula we can show hundred chart as well.

This is the way we can display the numbers in thousands in Microsoft Excel.

 

image 48

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

 
 

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