MrExcel's Learn Excel #879 - Icon Sets II

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Jan 5, 2009.
Excel 2007 offers a new visualization called an Icon Set. I usually hate this feature, because my numbers are right justified and the icons are left justified. However, in Episode 879, Joanna from Columbus, Ohio offers a cool tip to get the numbers and icons next to each other.
maxresdefault.jpg


Transcript of the video:
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Boy, a great tip today from Joanna-- Joanna in Columbus, Ohio.
I always talk about on the new Excel-- Excel 2007-- the data bars, which are cool; the color scales, which I like; but then I'm never big on the icon sets.
And the reason that I don't like the icon sets is they always left-justify the icon.
So right here, this green actually applies to the 897 number instead of the 915 number.
And so you have some pretty high numbers here like the 862 that appears to have a red icon next to it, and there's no way to get that icon off the left edge.
And so I always complain that I have to either Center my numbers-- which I despise centering the numbers, they just look horrible.
And I was doing a seminar about Excel 2007, and Joanna raised her hand.
She said, "Well, wait a second, there's a setting called Right Indent." And I don't know how I'd missed this, but sure enough, if we go into Format Cells, there are settings here to use right-indent and then we can control the number of characters we want to indent.
So if I take those numbers, and then indent them a certain number of characters-- maybe three-- what happens is, I move the numbers over.
Now, they still continue to justify against some imaginary right edge, and so it still looks like they're right-justified but the number now appears next to the label.
So using the number of characters to right-indent will now allow the numbers to kind of float over closer to the icons, and actually create a very nice visualization of the data with the traffic lights and the numbers right next to each other.
So I want to thank Joanna for that great idea-- using the Right Indent right there under Format Cells.
That's been there all the time, I guess never really realized exactly what it did-- but a great little trick.
And I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel.
 

Forum statistics

Threads
1,213,532
Messages
6,114,176
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top