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 Professional
AJP Excel information
New design - with lot of resources, tutorials, examples.
Nicely formatted vintage bar chart in Excel with highlighted data.
Easy vintage chart reproduction with some formatting.
Two version of line chart in Excel to visualize small and large number on one chart.
Spotlights chart in Excel using xy scatter chart to visualize film scores and profits.
Freddy: Aren't there any lights in this place?
One of the most useful formulas of Excel.
The new content page of our sites!
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.
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.
The purpose was to give an overview, a total picture without focusing on anything in particular.
An easy but useful feature for stacked bar charts.
One of the strengths of Tufte's graph (perhaps the most important) is that we can immediately read the ranking of both the data.
Easy-to-use dynamic solution.
An easy solution with explanation.
If you don’t have Excel 2013 then this post will be a bit like window shopping with an empty wallet. You get to try stuff on and test drive it, you just don’t get to take it home. Window shopping
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.
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.
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.
Use different data structures to create this chart: step-by-step tutorial.
Dynamic Excel chart to visualize small change in large values
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
Excel stacked column chart with lines lying on the top of the columns.
You can easily choose where do you want to see lines to highlight the movement of the data.
Rectangular range, two dimension range, matrix as chart data for line and column charts.
Visualize science: gene expression patterns.