Graphing / Rounding / Millions

Susan Swisher

Can I recreate this GRAPH / Dashboard

The numbers are defaulted to Millions; they are presented in our sheets as $5,100,000 and $3,180,000, respectively; however, for ease of visualization, we want to round them and graph them as shown.

HELP!

Ric T

Hi @Susan Swisher,

All good! Next to your columns where you have $5,100,000 and $3,180,000, you'll need to create a formula in another cell (helper column) that looks like:

=[Name of your column here]@row / 1000000

This gives you your desired output (screenshot below), then in your dashboard chart, highlight the column that you want to generate. Keep in mind that if you want everything to be 2 decimal points, you might need to increase decimal points (main toolbar) in your sheet.

Cheers,

Ric