FrankensTeam's Excel Collection
113.2K views | +26 today

# FrankensTeam's Excel Collection

Useful, interesting and funny Excel stuff
Curated by Kris
 Scooped by Kris

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

This quick tutorial shows how to use a hidden XY series to provide custom labels where desired along a chart's axis.
No comment yet.
 Scooped by Kris

## Excel Named Range Shortcut • My Online Training Hub

This Excel Named Range shortcut using the exclamation mark will enable you to create a global name with local scope.
No comment yet.
 Scooped by Kris

## Secondary Axis as Percentage of Target - Peltier Tech Blog

Usually, secondary axes are confusing and cognitively butrdensome. But this tutorial shows how a secondary axis with percentages can be a good thing.
No comment yet.
 Scooped by Kris

## Excel Waterfall Charts (Bridge Charts) - Peltier Tech Blog

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.

No comment yet.
 Scooped by Kris

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

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.

No comment yet.
 Scooped by Kris

## Spotlights chart in Excel - E90E50fx

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?

No comment yet.
 Scooped by Kris

## Dot Plots in Microsoft Excel - Peltier Tech Blog

Microsoft Excel doesn't have a native Dot Plot chart type. But you can build your own following these simple instructions.
No comment yet.
 Scooped by Kris

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

Considerations about chart scaling and baseline.

No comment yet.
 Scooped by Kris

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

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.
No comment yet.
 Scooped by Kris

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

Different color for up and down line segments in Excel charts.
No comment yet.
 Scooped by Kris

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

Dynamic Excel chart to visualize small change in large values
No comment yet.
 Scooped by Kris

## Perfect square plot area, perfect square gridlines - E90E50fx

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

No comment yet.
 Scooped by Kris

## Matrix bubble chart with Excel - E90E50fx

The purpose was to give an overview, a total picture without focusing on anything in particular.
No comment yet.
 Scooped by Kris

## Reciprocal Chart Axis Scale - Peltier Tech Blog

This tutorial uses an Arrhenius plot to demonstrate construction of an axis with arbitrary scale and gridlines, ordinarily not available in Excel.
No comment yet.
 Scooped by Kris

## Apply Custom Data Labels to Charted Points - Peltier Tech Blog

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.

No comment yet.
 Scooped by Kris

## Mapping relationships between people using interactive network chart

Today, lets learn how to create an interesting chart. This, called as network chart helps us visualize relationships between various people. Demo of interactive
No comment yet.
 Scooped by Kris

## Combine Bubble and xy scatter line chart - E90E50fx

Combine bubble and xy scatter line chart in excel - the trick is to use trendline
Kris's insight:

Useful, simple and ingenious idea!!

No comment yet.
 Scooped by Kris

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

Generate QR code with google chart API using UDF in Excel

No comment yet.
 Scooped by Kris

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

Axis labels in a bar chart can obstruct negative bars. This tutorial shows a way to place labels across the axis from the data.
No comment yet.
 Scooped by Kris

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

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!

No comment yet.
 Scooped by Kris

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

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

No comment yet.
 Scooped by Kris

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

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

No comment yet.
 Scooped by Kris

## Error bar begin and end style setting differences - E90E50fx

Error bar differences in Excel 2010 and 2013: begin and end points changed
No comment yet.
 Scooped by Kris

## Multiple Width Overlapping Column Chart - Peltier Tech Blog

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.
No comment yet.
 Scooped by Kris

## How defined names are calculated - chart example - E90E50fx

How and when Excel calculates the defined names? Explained using a chart with random data.
No comment yet.