How to Create an Excel Interactive Chart with Dynamic Arrays - Excel Tips and Tricks - video Dailymotion

ExcelTips247

Learn how to create an Excel interactive chart with dynamic array. Technically, is an example of How do I create a dynamic bar chart in Excel Or How do you make a dynamic bar chart? This tip and tricks also works for question like What are dynamic charts that update automatically in excel. And how do I create a dynamic range in Excel? And finally answers to question on how to make an Excel dynamic chart & keep updates consistent?   Excel is a powerful tool for data analysis and visualization, and one of its standout features is the ability to create interactive charts. Interactive charts allow users to explore and analyze data dynamically, providing a more engaging and flexible experience. In this article, we will focus on creating an interactive chart with dynamic arrays in Excel.   Before we delve into the specifics of creating dynamic charts, let's first understand what dynamic arrays are. Dynamic arrays are a new feature introduced in Excel 365 and Excel 2021 that allow you to work with arrays of values, such as formulas or functions, that can automatically spill into multiple cells. This functionality is particularly useful when dealing with large datasets or when you need to perform calculations across multiple cells simultaneously.   Create Month List  1) Select cell B2  2) Data ~ Data Validation  3) Set Allow to List  4) Source as =$A$16:$A$87  5) Apply   Filter Table  1) Select cell A5  2) =FILTER(A13:C84,(A13:A84=B2),"")   Draw Bar Chart  1) Highlight filtered table (console and sales)  2) Insert ~ Clustered Bar Chart  3) Select x-axis and delete it  4) Right-click on the bar chart, Format  5) Disable Legend     Remove Title     Horizontal Axis, Uncheck Display axis     Series 1, enable Data Labels               Fill to Red               Label position Center  6) Position the chart to cover Filter Table    How to Create an Excel Interactive Chart with Dynamic Arrays,How do I create a dynamic bar graph in Excel?,How do you make a dynamic bar chart?,What are dynamic charts that update automatically in Excel?,How do I create a dynamic range in Excel?,How to Make an Excel Dynamic Chart & Keep Updates Consistent,

Transcript

00:00This is how you can create a simple dynamic bar chart that changes when you

00:03select different month of the year from the pulldown menu. So let's start off by

00:07creating the pulldown menu. Select this cell here, make sure you're in data, data

00:12validation and then from the allow you're gonna select list and the source

00:17will be the month from A16 all the way down to A87 and hit apply. What this

00:23does is that it creates a pulldown menu here for you as you can see you have all

00:28the months here. I'm going to select a month like this. Next we're going to

00:31create a filter table here. The formula will be equal filter and the first

00:38argument on the filter would be the whole data set for the console sale. I'm gonna go

00:44all the way up there. The second argument will be a condition. So basically you're

00:48looking for the month. So we're gonna be A16 all the way down to A87 like this and

00:54since this is gonna be a condition we're gonna say equal to this cell here when

01:00you select the month and then the second one will be for empty. I'm gonna leave it

01:05blank like this and hit enter. This should create a table like that for you and if

01:09you try it out you can see that table should change accordingly depending on

01:14what month you select. Next we're gonna insert a bar chart. Select the filter table

01:19console and sale column like this and after that go insert and from this insert

01:24chart pulldown you're gonna select clustered bar like this and this should

01:28draw a chart for you based on these two columns here and then after that let's

01:33reposition this somewhere at the center here nicely like this and then start

01:38making edits to the bar chart like this

01:49now every time you make changes to the month of the year like this the bar chart

02:06will dynamically get updated based on the filtered data set that you previously

02:10created

How to Create an Excel Interactive Chart with Dynamic Arrays - Excel Tips and Tricks

Category

Transcript

Comments

Recommended