FrankensTeam's Excel Collection
113.2K views | +26 today
Follow
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!

Column Chart with Category Axis Labels Between Columns - Peltier Tech Blog

Column Chart with Category Axis Labels Between Columns - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
This quick tutorial shows how to use a hidden XY series to provide custom labels where desired along a chart's axis.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Excel Named Range Shortcut • My Online Training Hub

Excel Named Range Shortcut • My Online Training Hub | FrankensTeam's Excel Collection | Scoop.it
This Excel Named Range shortcut using the exclamation mark will enable you to create a global name with local scope.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Secondary Axis as Percentage of Target - Peltier Tech Blog

Secondary Axis as Percentage of Target - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
Usually, secondary axes are confusing and cognitively butrdensome. But this tutorial shows how a secondary axis with percentages can be a good thing.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Excel Waterfall Charts (Bridge Charts) - Peltier Tech Blog

Excel Waterfall Charts (Bridge Charts) - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
Waterfall charts (bridge charts) are not native to Microsoft Excel; this tutorial shows several ways to manually make waterfall charts of varying complexity.
Kris's insight:

All about waterfall charts. Approach Using Up-Down Bars is the best one.

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

Microsoft Excel VLOOKUP and CHOOSE formula to lookup columns to the left

Microsoft Excel VLOOKUP and CHOOSE formula to lookup columns to the left | FrankensTeam's Excel Collection | Scoop.it
In this quick Excel tutorial we look at how to use the VLOOKUP formula with the CHOOSE function to look up columns to the left as an alternative to the INDEX and MATCH functions.
Kris's insight:

Easy! It will be a good material for my beginners.

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

Spotlights chart in Excel - E90E50fx

Spotlights chart in Excel - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Spotlights chart in Excel using xy scatter chart to visualize film scores and profits.
Kris's insight:

Freddy: Aren't there any lights in this place?

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

Dot Plots in Microsoft Excel - Peltier Tech Blog

Dot Plots in Microsoft Excel - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
Microsoft Excel doesn't have a native Dot Plot chart type. But you can build your own following these simple instructions.
more...
No comment yet.
Scooped by Kris
Scoop.it!

storytelling with data: a little math on non-zero baselines

storytelling with data: a little math on non-zero baselines | FrankensTeam's Excel Collection | Scoop.it

Considerations about chart scaling and baseline.

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

Combine pie and xy scatter charts - Advanced Excel Charting Example | Chandoo.org - Learn Microsoft Excel Online

Combine pie and xy scatter charts - Advanced Excel Charting Example | Chandoo.org - Learn Microsoft Excel Online | FrankensTeam's Excel Collection | Scoop.it
Few days ago, we learned how to create a pie+donut combination chart to visualize polls around the world in 2014. It generated quite a bit of interesting discussion (47 comments so far). One of the comments was from Roberto, who along with Kris & Gábor runs The FrankensTeam an online library of advanced Excel tricks, charts and other mind-boggling spreadsheet wizardry. I really liked Roberto's comments on the original post and a charting solution he presented. So I asked him if he can do a guest post explaining the technique to our audience. He obliged and here we go. Over to FrankensTeam.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Different color for up and down line segments in an Excel chart - E90E50fx

Different color for up and down line segments in an Excel chart - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Different color for up and down line segments in Excel charts.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Visualize small change in large number - split the data - E90E50fx

Visualize small change in large number - split the data - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Dynamic Excel chart to visualize small change in large values
more...
No comment yet.
Scooped by Kris
Scoop.it!

Perfect square plot area, perfect square gridlines - E90E50fx

Perfect square plot area, perfect square gridlines - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

Easy way to create perfect square plot area and gridlines in Excel chart

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

Matrix bubble chart with Excel - E90E50fx

Matrix bubble chart with Excel - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
The purpose was to give an overview, a total picture without focusing on anything in particular.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Reciprocal Chart Axis Scale - Peltier Tech Blog

Reciprocal Chart Axis Scale - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
This tutorial uses an Arrhenius plot to demonstrate construction of an axis with arbitrary scale and gridlines, ordinarily not available in Excel.
more...
No comment yet.
Scooped by Kris
Scoop.it!

Apply Custom Data Labels to Charted Points - Peltier Tech Blog

Apply Custom Data Labels to Charted Points - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
This tutorial describes a number of ways (manual, built-in, and programmatic) to add custom data labels to an Excel chart.
Kris's insight:

Great summary about the labeling possibilities.

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!

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!

Axis Labels That Don't Block Plotted Data - Peltier Tech Blog

Axis Labels That Don't Block Plotted Data - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
Axis labels in a bar chart can obstruct negative bars. This tutorial shows a way to place labels across the axis from the data.
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!

Multiple lines across categories - simple step by step guide - E90E50fx

Multiple lines across categories - simple step by step guide - E90E50fx | FrankensTeam's Excel Collection | Scoop.it

Use different data structures to create this chart: step-by-step tutorial.

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!

Error bar begin and end style setting differences - E90E50fx

Error bar begin and end style setting differences - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Error bar differences in Excel 2010 and 2013: begin and end points changed
more...
No comment yet.
Scooped by Kris
Scoop.it!

Multiple Width Overlapping Column Chart - Peltier Tech Blog

Multiple Width Overlapping Column Chart - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
I read a post entitled Calling All Graph Wizards – Overlapping/Stacking Graphs w/o secondary axis on the Mr Excel forum today, and decided the question was broad enough and the answer quick and elegant enough that it was worth sharing.
more...
No comment yet.
Scooped by Kris
Scoop.it!

How defined names are calculated - chart example - E90E50fx

How defined names are calculated - chart example - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
How and when Excel calculates the defined names? Explained using a chart with random data.
more...
No comment yet.