You are the content you publish.
Sign up with Facebook
Sign up with Twitter
I don't have a Facebook or a Twitter account
Start a free trial of Scoop.it Business
Combine bubble and xy scatter line chart in excel - the trick is to use trendline
Useful, simple and ingenious idea!!
Are you sure you want to delete this scoop?
The Peltier Tech Chart Utility has a new Advanced Edition, which nearly doubles the capabilities of the Standard Edition.
Great tool! It makes very easy to create lots of clear, useful business charts.
Generate QR code with google chart API using UDF in Excel
How to create an interactive “Pivot-like” Marimekko Chart in Excel allowing the user to select the visualized dimensions and measure on the fly
One more solution form Marimekko charts.
Many times it causes problems - here is solution.
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.
How to use Excel chart templates.
This tutorial covers VBA and non-programmatic ways to highlight the maximum in a chart by changing the data label formatting.
Microsoft Excel doesn't have a native Dot Plot chart type. But you can build your own following these simple instructions.
Roberto Mensa and his team have proposed a UDF alternative to Jon's recent VBA approaches to plot gaps in Excel charts.
Our guest post!
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.
Error bar differences in Excel 2010 and 2013: begin and end points changed
Easy way to create perfect square plot area and gridlines in Excel chart
Having your Excel data in a tabular format will make it easy to analyse with Pivot Tables and save you hours of frustration.
"You might think you’re saving time by skipping this step but it will eventually come back to haunt you".... so true...
Excel Tabular Data is the Ideal Format for PivotTables and Formulas
This is an index of Pivot-Table-related posts on the Peltier Tech blog, and a list of three good Pivot Table books.
All about Pivot tables.
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.
Easy! It will be a good material for my beginners.
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.
A VBA based Microsoft Excel Template to create a Marimekko Chart aka Matrix Chart aka Mosaic Chart for free download
Really good solution for a simple chart which could not be done easily in Excel.
Axis labels in a bar chart can obstruct negative bars. This tutorial shows a way to place labels across the axis from the data.
Article about using Pivottable slicers in Excel 2010; Synchonising slicers
Useful for practice!
After you create a pivot table, you can enhance the results by writing your own formulas, to create calculated fields and calculated items.
Great summary and examples.
The basics of Getpivotdata.
In my practice, Getpivotdata is very-very useful for building reports.
An set of articles into mememory use, timing and multithreading in Excel
Very useful stuff to understand how things work in the dark depth of Excel. :-)
Different color for up and down line segments in Excel charts.
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.
Today's conclusion: I will teach INDEX to all my colleagues.