Highlighting Data Points in Scatter and Line Charts
Introducing a method of allowing data points to be interactively highlighted in Excel Scatter / X-Y Charts and Line Charts.
You will see a lot of these style charts in various places where you want to highlight various aspects of the chart to your audience. It is a great technique for complex scientific and engineering charts where you may have hundreds or thousands of points.
How to show Indian Currency Format in Excel?
This is a guest post by our excel ninja – Hui. Today we will learn how to format numbers and amounts in Indian currency format. Indian numbers are grouped differently than standard English numbers. English Grouping 123,456,789.01 Indian Grouping 12,34,56,789.01 Quick and easy fix to show numbers in Indian format: A custom number format of: […]
Data Tables & Monte Carlo Simulations in Excel – A Comprehensive Guide
If anybody asks me what is the best function in excel I am drawn between Sumproduct and Data Tables, Both make handling large amounts of data a breeze, the only thing missing is the Spandex Pants and Red Cape!
How often have you thought of or been asked “I’d like to know what our profit would be for a number of values of an input variable” or “Can I have a graph of Profit vs Cost”
This post is going to detail the use of the Data Table function within Excel, which can help you answer that question and then so so much more.
Data Validation using an Unsorted column with Duplicate Entries as a Source List
Here is a typical scenario: We want to allow only one of the pre-defined customer names in our spreadsheet. We have listed down all the customers in column B and want excel to check against this list and validate the data. But there are 3 problems. (1) Our list is not sorted alphabetically (2) It contains duplicates and (3) The list comes from external source, so we can not remove duplicates and sort the list every time.
Now how can we set up a simple data validation list that would not repeat customer names and shows them in sorted order like this.
Read the rest of this guest post by Hui to learn how to use data validation in creative new ways.