Hello all. Fancy dynamic graphs that changes based on selected inputs part of drop down list? Like the below: Let’s look at the steps in creating this dynamic graphs. We would be performing the following steps to achieve this: Convert the data set to a table Create a simple graph based on the table CreateContinue reading “How to create dynamic graphs – Change graph based on values in drop down”
Tag Archives: Offset in excel
Using “OFFSET” in Excel
Hello All. Offset is a cool, built in function of Excel that is used to return a specific value or a range that is a specified number of rows and columns from a reference cell. Might sound confusing – but let’s look at few examples which will help us to understand. First, the syntax: =Offset(Reference,Continue reading “Using “OFFSET” in Excel”