FrankensTeam's Ex...
Follow
Find tag "innovative"
52.4K views | +63 today
FrankensTeam's Excel Collection
Useful, interesting and funny Excel stuff
Curated by Kris
Your new post is loading...
Your new post is loading...
Scooped by Kris
Scoop.it!

Motion Chart Excel Template - Clearly and Simply

Motion Chart Excel Template - Clearly and Simply | FrankensTeam's Excel Collection | Scoop.it
A generic template to create Motion Charts in Microsoft Excel and 2 examples to animate La Linea episodes in Excel
Kris's insight:

Nice!

more...
No comment yet.
Scooped by Kris
Scoop.it!

Combine Bubble and xy scatter line chart - E90E50fx

Combine Bubble and xy scatter line chart - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Combine bubble and xy scatter line chart in excel - the trick is to use trendline
Kris's insight:

Useful, simple and ingenious idea!!

more...
No comment yet.
Scooped by Kris
Scoop.it!

Generate QR code with google chart API using UDF in Excel - E90E50fx

Generate QR code with google chart API using UDF in Excel - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

Generate QR code with google chart API using UDF in Excel

more...
No comment yet.
Scooped by Kris
Scoop.it!

Marimekko Charts in Microsoft Excel - Clearly and Simply

Marimekko Charts in Microsoft Excel - Clearly and Simply | FrankensTeam's Excel Collection | Scoop.it
A VBA based Microsoft Excel Template to create a Marimekko Chart aka Matrix Chart aka Mosaic Chart for free download
Kris's insight:

Really good solution for a simple chart which could not be done easily in Excel.

more...
No comment yet.
Scooped by Kris
Scoop.it!

Another approach to plotting gaps in Excel charts - Peltier Tech Blog

Another approach to plotting gaps in Excel charts - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
Roberto Mensa and his team have proposed a UDF alternative to Jon's recent VBA approaches to plot gaps in Excel charts.
Kris's insight:

Our guest post!

more...
No comment yet.
Scooped by Kris
Scoop.it!

Calendar Control for All Office versions - including Office 2010 64 bit - E90E50

Calendar Control for All Office versions - including Office 2010 64 bit - E90E50 | FrankensTeam's Excel Collection | Scoop.it

The universal Calendar Control can not miss from this collection. Check the Updates section for more features and usage examples.

more...
No comment yet.
Scooped by Kris
Scoop.it!

Talent traffic chart with chord diagram in Excel - E90E50fx

Talent traffic chart with chord diagram in Excel - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Talent traffic chart with chord diagram in Excel
Kris's insight:

It was a great team-work to develop and improve this brand-new Excel chart.

more...
Scooped by Kris
Scoop.it!

Anatomy of an Excel chart - Cosmograph dynamic version - E90E50fx

Anatomy of an Excel chart - Cosmograph dynamic version - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

Here is the improved, dynamic version of cosmograph with new features - illustrated with an anatomy picture.

more...
No comment yet.
Scooped by Kris
Scoop.it!

Life Expectancy by Nathan Yau's chart with Excel

Life Expectancy by Nathan Yau's chart with Excel | FrankensTeam's Excel Collection | Scoop.it

This new Excel work was inspired by Nathan Yau's chart to look at life expectancy over time and by country.

more...
No comment yet.
Scooped by Kris
Scoop.it!

Excel data validation with on-the-fly update without VBA

Excel data validation with on-the-fly update without VBA | FrankensTeam's Excel Collection | Scoop.it

Hierarchical dynamic validation list with a plus: type the name of new element if you do not find it. It will be part of the list immediately!

more...
Progressive training's curator insight, November 19, 2013 12:50 PM

Excel data validation with on-the-fly update without VBA

 

#microsoft #excel #training 

 

Scooped by Kris
Scoop.it!

Stacked and separated dynamic Excel charts - E90E50fx

Stacked and separated dynamic Excel charts - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

This dynamic solution serves both visualization needs: compare the total and compare the categories too.

more...
No comment yet.
Scooped by Kris
Scoop.it!

E90E50charts - Excel Charts Gallery

E90E50charts - Excel Charts Gallery | FrankensTeam's Excel Collection | Scoop.it
Microsoft Excel charts and data visualization tools
Kris's insight:

Excel chart gallery opened. We would be happy if write your comments in the Visitor's book.

 

more...
Oz du Soleil's curator insight, July 31, 2013 10:14 AM

Check out these unique and interesting Excel charts. And be sure to comment in the visitor's book.

Scooped by Kris
Scoop.it!

Simple calendar-based heatmap in Excel

Simple calendar-based heatmap in Excel | FrankensTeam's Excel Collection | Scoop.it

Visualize 10 years metro usage.

Kris's insight:

Could also be useful for sales data.

more...
No comment yet.
Scooped by Kris
Scoop.it!

Mapping relationships between people using interactive network chart

Mapping relationships between people using interactive network chart | FrankensTeam's Excel Collection | Scoop.it
Today, lets learn how to create an interesting chart. This, called as network chart helps us visualize relationships between various people. Demo of interactive
more...
No comment yet.
Scooped by Kris
Scoop.it!

Drill Up and Down on Choropleth Maps in Excel - Clearly and Simply

Drill Up and Down on Choropleth Maps in Excel - Clearly and Simply | FrankensTeam's Excel Collection | Scoop.it
Interactive drill up and down geographical hierarchies on a Choropleth Map in Microsoft Excel
Kris's insight:

Really awesome #Excel magic by Robert Mundigl.

more...
Trainedge Consulting's curator insight, June 26, 2014 2:25 AM
Interactive drill up and down geographical hierarchies on a Choropleth Map in Microsoft Excel.
Scooped by Kris
Scoop.it!

Pivot-like Marimekko Charts in Excel - Clearly and Simply

Pivot-like Marimekko Charts in Excel - Clearly and Simply | FrankensTeam's Excel Collection | Scoop.it
How to create an interactive “Pivot-like” Marimekko Chart in Excel allowing the user to select the visualized dimensions and measure on the fly
Kris's insight:

One more solution form Marimekko charts.

more...
No comment yet.
Scooped by Kris
Scoop.it!

Use slicers to create interactive, dynamic Excel charts and dashboards - E90E50fx

Use slicers to create interactive, dynamic Excel charts and dashboards - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Simple, innovative technique to create interactive and dynamic charts and dashboards with slicers in Excel.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Robust Dynamic (Cascading) Dropdowns Without VBA | Chandoo.org - Learn Microsoft Excel Online

Robust Dynamic (Cascading) Dropdowns Without VBA | Chandoo.org - Learn Microsoft Excel Online | FrankensTeam's Excel Collection | Scoop.it
Find out how to set up cascading dynamic dropdowns using Excel's Data Validation that users must manually clear if they later make changes - without VBA
Kris's insight:

Solution with only one named formula.

more...
No comment yet.
Scooped by Kris
Scoop.it!

SUM by color: Calculate when color changed

SUM by color: Calculate when color changed | FrankensTeam's Excel Collection | Scoop.it
Trigger calculation when color or other formatting changed.
more...
Progressive training's curator insight, November 25, 2013 11:21 AM

SUM by color: Calculate when color changed

Scooped by Kris
Scoop.it!

Cosmograph in Excel - World migration with bilateral flow chart - E90E50fx

Cosmograph in Excel - World migration with bilateral flow chart - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

Take a look at this fantastic visual result!

Kris's insight:

Unbelievable that this chart could be done in Excel!

more...
Oz du Soleil's comment, September 23, 2013 2:48 PM
I've seen this before but I think it had been built in R. It's great to know that this is yet one more thing that Excel can handle.
Scooped by Kris
Scoop.it!

Edward Tufte's Slopegraphs in Excel - E90E50fx

Edward Tufte's Slopegraphs in Excel - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
One of the strengths of Tufte's graph (perhaps the most important) is that we can immediately read the ranking of both the data.
Kris's insight:

Easy-to-use dynamic solution.

more...
No comment yet.
Scooped by Kris
Scoop.it!

Variable width histogram - assign values to ranges

Variable width histogram - assign values to ranges | FrankensTeam's Excel Collection | Scoop.it
Kris's insight:

Two different solutions for the same topic.

more...
No comment yet.