Format Chart Numbers as Thousands or Millions
Recently I have been creating some comparison charts (prior year agains projections) and usually the numbers in my tables have been in a format which would suit. In this recent project though the data was in large whole numbers and I wanted to format this into a chart so it appeared as millions. In order to get from whole numbers to millions I had to work with the number format in what was a slightly unintuitive way and I hope by sharing this that I save you some time in the process.
Read MoreFeatured Posts
Recent Posts
Split File into Parts and Save to Directory April 20, 2024
Most Popular Author December 14, 2023
Creating an Excel Dashboard - A Guide with Templates December 8, 2023
Real Estate Excel Dashboard October 11, 2023
Updating Excel Dashboards September 29, 2023
TheSmallman in Another Top Blog Rank April 24, 2023
Project Tracking Dashboard March 25, 2023
Excel Unique Formula September 17, 2022
Horizontal Range to Vertical Range in Excel June 15, 2022
Hiding Rows Quickly with VBA May 20, 2022