Wrapping up new visualizations – icon sets

re: Wrapping up new visualizations – icon sets

Rob van Gelder — Mon, 10 Oct 2005 08:45:02 GMT

Don't forget Smiley :), Straight :|, Frownie :( faces.

oh, and... just for Harlan... a special icon that blinks! ;)

re: Wrapping up new visualizations – icon sets

Jeffrey McManus — Mon, 10 Oct 2005 08:52:15 GMT

This sounds terrific, I will definitely use these features.

re: Wrapping up new visualizations – icon sets

Jordan Windebank — Mon, 10 Oct 2005 09:13:37 GMT

Hi David,

This function looks fantastic, much like the other new features in Excel '12'. Will these icons be customizable by the user if they wish to add their own grahpics?

Thanks,
Jordan

re: Wrapping up new visualizations – icon sets

Andy Cotgreave — Mon, 10 Oct 2005 11:23:28 GMT

Wow! That looks great. I'm not sure all of the icons represent an "obvious" message, for example, why is a down left-pointing arrow "better" or "worse" than a down right-pointing arrow?

But, the traffic lights, flags and moon phases look excellent.

re: Wrapping up new visualizations – icon sets

Helen — Mon, 10 Oct 2005 11:52:10 GMT

Not as exciting as colour scales or data bars, but can probably come in handy.

Please ask the artwork guys to provide options that print well, and differ in more than just colour. The arrows and pies are great and will be used frequently, I'm sure - and the ones you've shown here look like they'll print well.

Crosses & check marks was the other icon set I immediately looked for, and the example in your picture looks a lot less printer-friendly than the arrows. Both will come out as circles in print, and look very similar. Solid check mark-shaped check marks would be good to have (such as the ones in the wingdings font, characters 00FB and 00FB).

re: Wrapping up new visualizations – icon sets

Stephen Bullen — Mon, 10 Oct 2005 13:47:08 GMT

Another plea for consideration for the colour-impaired. The reds and greens used in the '3D' icons are indistinguishable to me.

re: Wrapping up new visualizations – icon sets

imtiyaz — Mon, 10 Oct 2005 16:09:23 GMT

That's really great!!!

selectable icons?

Tianwei — Mon, 10 Oct 2005 17:44:04 GMT

David, this is going to be a tremendously popular feature apart from the new charting templates.

Question on icons. Inevitably almost every "dashboards" will have a few metrics unique enough that at times there is the need to manually "override" the system assigned categorizations. For example, for a growing portfolio, a negative net income might not be true "red" as long as it's less than the plan. So I wonder if Excel will make manual insert of icons (or manual overrides) possible. Of course come with that question is the ability afterwards to systemically sweep the sheet for spotting the manually created icons. I know I'm asking a lot yet this is so commonplace.

re: Wrapping up new visualizations – icon sets

Bob Whiton — Tue, 11 Oct 2005 19:58:32 GMT

I can definitely see our application making use of this new feature. Great feature!

re: Wrapping up new visualizations – icon sets

David Gainer — Tue, 11 Oct 2005 21:03:47 GMT

Howdy,

All – Thanks for the feedback. Glad you like what you see.

Jordan – Unfortunately, this time out, users will be limited to the set of icons we ship with Excel 12.

Andy – We have tried to assemble a range of icons that will handle a wide range of situations, but not all make sense in all situations. Arrows are commonly used to communicate trends.

Helen – We are going to make sure they print well, and thanks for your other feedback.

Stephen – We tried to make sure that some of the red/yellow/green had other visual cues (shape, characters). Is there something else you think we should do? Feel free to send me an email using the link at the top of the page.

Tianwei – If I am understanding correctly, I think the situation you are describing is a good example of where using a formula to specify the criteria for a conditional format is the appropriate choice – with formulas, you can specify these sorts of conditions. A very common example is from budgeting – if “actual” is more than 20% over “budget” turn the font red unless the difference between the two is less than $500 (in which case the variance is immaterial).

re: Wrapping up new visualizations – icon sets

Tianwei — Wed, 12 Oct 2005 16:00:59 GMT

David, what I was referring to is the ability to manually insert an icon to override the forumula driven icon. Let's say I apply an overall formula say if the value is negative then turn the red light on. But one of the cells in the array is negative but I need it to show yellow because this is an anticipated situation where negative values is normal. Instead of creating a separate formula for that cell, I'd want to temporarily place a yellow light in that cell for quick fix.

re: Wrapping up new visualizations – icon sets

Mark O — Wed, 12 Oct 2005 17:24:20 GMT

Please make these icons print well. It would be very helpful to include check boxes in the icon set.

re: Wrapping up new visualizations – icon sets

Vic Eldridge — Mon, 17 Oct 2005 11:30:16 GMT

Can Icon Sets, Colour Scaling and Data Bars all be assigned to a range at the same time ?

re: Wrapping up new visualizations – icon sets

Matthew — Mon, 17 Oct 2005 20:30:17 GMT

David,
Another great feature that I can see getting a lot of use.

I have one request/suggestion for the available icons, could you consider including a double-ended horizontal arrow (As if to suggest a value which has remained equal)?

Thanks.

re: Wrapping up new visualizations – icon sets

Findeo — Mon, 24 Oct 2005 11:45:09 GMT

Great idea, but What about blinks?

PivotTables 11: Key Performance Indicators, Actions, and Named Sets

Microsoft Excel 12 — Thu, 09 Feb 2006 08:28:39 GMT

Today, I will cover three additional features of Analysis Services that Excel 12 PivotTables supprt –...

Conditional Formatting Trick 2 – How to get an icon in some cells, but not all cells

Microsoft Excel 2007 (nee Excel 12) — Wed, 10 May 2006 08:03:08 GMT

A few months ago, I described the new features we have added to Excel 2007 in the area of conditional...

Microsoft Excel 2007 Conditional Formating

Melville Thomson's Blog — Wed, 10 May 2006 13:04:56 GMT

A lot of you out there like to use Excel for your reporting, there are some great features in Excel 2007...

excel icons

excel icons — Sat, 24 May 2008 21:06:44 GMT

PingBack from http://simone.clearviewtickets.info/excelicons.html