FrankensTeam's Ex...
Follow
Find tag "useful"
33.8K views | +49 today
FrankensTeam's Excel Collection
Useful, interesting and funny Excel stuff
Curated by Kris
Your new post is loading...
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!

The Advanced Chart Utility Is Here - Peltier Tech Blog

The Advanced Chart Utility Is Here - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it

The Peltier Tech Chart Utility has a new Advanced Edition, which nearly doubles the capabilities of the Standard Edition.

Kris's insight:

Great tool! It makes very easy to create lots of clear, useful business charts.

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!

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!

Warning For Grouped Sheets | Contextures Blog

Warning For Grouped Sheets | Contextures Blog | FrankensTeam's Excel Collection | Scoop.it
Kris's insight:

Many times it causes problems - here is solution.

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

Excel Chart Templates

Excel Chart Templates | FrankensTeam's Excel Collection | Scoop.it
Setting up a custom Excel chart templates can save you loads of time. If there’s a chart you use often you can also set it up as the default chart.
Kris's insight:

How to use Excel chart templates.

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

Highlight a Specific Data Label in an Excel Chart - Peltier Tech Blog

Highlight a Specific Data Label in an Excel Chart - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
This tutorial covers VBA and non-programmatic ways to highlight the maximum in a chart by changing the data label formatting.
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!

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!

Quickly combine text in multiple cells using this trick! [Formulas] | Chandoo.org - Learn Microsoft Excel Online

Quickly combine text in multiple cells using this trick! [Formulas] | Chandoo.org - Learn Microsoft Excel Online | FrankensTeam's Excel Collection | Scoop.it
Ever wondered how to go from a bunch of cells with text to one big combined text? Like shown above. Well, there is a simple trick. One of our readers, Grant shared this with us. Read on to learn this.
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!

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!

Excel Tabular Data is the Ideal Format for PivotTables and Formulas

Excel Tabular Data is the Ideal Format for PivotTables and Formulas | FrankensTeam's Excel Collection | Scoop.it
Having your Excel data in a tabular format will make it easy to analyse with Pivot Tables and save you hours of frustration.
Kris's insight:

"You might think you’re saving time by skipping this step but it will eventually come back to haunt you".... so true...

more...
Progressive training's curator insight, November 19, 2013 9:45 AM

Excel Tabular Data is the Ideal Format for PivotTables and Formulas

 

#excel #training 

 

Scooped by Kris
Scoop.it!

Pivot Table Resources - Peltier Tech Blog

This is an index of Pivot-Table-related posts on the Peltier Tech blog, and a list of three good Pivot Table books.
Kris's insight:

All about Pivot tables.

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!

Link Excel Chart Axis Scale to Values in Cells - Peltier Tech Blog

Link Excel Chart Axis Scale to Values in Cells - Peltier Tech Blog | FrankensTeam's Excel Collection | Scoop.it
This tutorial shows examples of code to update an Excel chart's axis scales on demand or on worksheet changes, using scale parameters from worksheet cells.
Kris's insight:

Frequently needed!

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!

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!

Pivottable slicers Excel 2010: Synchonising Slicers

Article about using Pivottable slicers in Excel 2010; Synchonising slicers
Kris's insight:

Useful for practice!

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

Calculated Field vs Calculated Item

Calculated Field vs Calculated Item | FrankensTeam's Excel Collection | Scoop.it

After you create a pivot table, you can enhance the results by writing your own formulas, to create calculated fields and calculated items.

Kris's insight:

Great summary and examples.

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

Excel Pivot Table Tutorial -- GetPivotData

Excel Pivot Table Tutorial -- GetPivotData | FrankensTeam's Excel Collection | Scoop.it

The basics of Getpivotdata.

Kris's insight:

In my practice, Getpivotdata is very-very useful for building reports.

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

An Investigation into the Performance of Excel

An set of articles into mememory use, timing and multithreading in Excel
Kris's insight:

Very useful stuff to understand how things work in the dark depth of Excel. :-)

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!

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!

The Imposing INDEX - Excel Hero Blog

The Imposing INDEX - Excel Hero Blog | FrankensTeam's Excel Collection | Scoop.it
Kris's insight:

Today's conclusion: I will teach INDEX to all my colleagues.

more...
No comment yet.