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
Insert hyperlinks in Excel with data validation lists and and spin buttons.
Are you sure you want to delete this scoop?
Combine bubble and xy scatter line chart in excel - the trick is to use trendline
Useful, simple and ingenious idea!!
Nicely formatted vintage bar chart in Excel with highlighted data.
Easy vintage chart reproduction with some formatting.
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
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.
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.
Two version of line chart in Excel to visualize small and large number on one chart.
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.
Spotlights chart in Excel using xy scatter chart to visualize film scores and profits.
Freddy: Aren't there any lights in this place?
Simple, innovative technique to create interactive and dynamic charts and dashboards with slicers in Excel.
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.
One of the most useful formulas of Excel.
Vintage chart reproduction in Excel: arrows starting from one point.
Interactive drill up and down geographical hierarchies on a Choropleth Map in Microsoft Excel
Really awesome #Excel magic by Robert Mundigl.
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.
Download English version Deutsche Version herunterladen
Well, I am not interested in football, but this tool looks really eye-catching for a lady too. I really like the ribbon tool - that is amazing!
Let the game begin!
Generate QR code with google chart API using UDF in Excel
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.
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.
Visualize maths in Excel: Witch of Agnesi curve animated chart
One more visualize maths chart about a funny-named curve.
New chart type in Excel: stacked column flow chart to visualize change of percentages by time.
Visualize mathematics in Excel using formulas and animated charts.
Caution! Addictive! :-)
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!