Introducing Javascript Charting | ag-Grid

Introducing Javascript Charting | ag-Grid

The charts in ag-Grid are tightly integrated such that the charting component understands the columns and rows contained in the grid. This level of integration means both application users and developers are capable of creating charts from the data inside the grid

Last year at our London and New York conferences, we asked attendees what they wanted to see in future versions of ag-Grid. By far the most requested feature was Charting.

This was a bit of a surprise for us as there are numerous excellent charting libraries already available. Probing further we discovered that while some companies may provide a grid and a charting library, it’s up to the developer to tie the two together. Instead, what developers are searching for is a grid with integrated charts.

Six months later we are very excited to announce that Integrated Chartsare now available in ag-Grid Enterprise v21.

The charts in ag-Grid are tightly integrated such that the charting component understands the columns and rows contained in the grid. This level of integration means both application users and developers are capable of creating charts from the data inside the grid.

User-Created Charts

To kick things off, let’s take a look at how application users can now create charts from inside the grid.

The idea here is to give users a charting experience like that found in spreadsheet applications such as Excel but even better as it can be done inside your applications.

Users start by selecting a range of cells and then choosing a chart from the grids context menu as shown below:

Chart Ranges appear in the grid when the chart is created. These highlight the category and series data being charted.

The columns are identified as chart category columns (these appear on an axis e.g. country names) or series columns (the numeric values getting charted).

Adjusting Chart Ranges

A Range Handle appears at the bottom right of the series range. This can be used to adjust the range of data as illustrated below:

Notice that the category and series ranges are kept in sync as the number of rows in the series range changes. Also notice while adjusting the chart ranges the chart becomes partially transparent to help see the grid data.

Updating Chart Settings

Once a chart is created, users can perform further actions from the Chart Toolbar. The toolbar appears when the mouse hovers over the top right area of the chart.

The first item in the toolbar launches the Chart Settings Panel. This panel allows users to change the selected chart type and color palette as demonstrated below:

In this first release the most popular charts are included. We plan more chart types to be added soon.

Changing Chart Data

The second toolbar item launches the Chart Data Panel. This panel allows users to change the category and series columns used in the chart. This is demonstrated below:

Notice that when the category and series columns are changed the chart range is also updated to reflect the new chart data.

Data Changes

Any updates to data in the grid are immediately shown in the charts. These updates could be due to user actions when cell editing, filtering, sorting, etc. Application updates that change grid data will also be reflected in the charts.

The illustration below shows how editing cell data in the grid updates the chart:

You can try out all of the features described above on our demo page.

Application Created Charts

So far we have seen how users can create charts inside ag-Grid, but what about the application creating charts without need the user to select ranges and chart from the menu?

Charts can be pre-defined or created dynamically from within applications, and as with user-created charts, these charts also benefit from the integration provided with the grid. This is done using the new Chart API.

A dummy financial application is presented below to give a taste of what’s possible:

If you want to experiment with this example for yourself, it can be found here.

In the example above you’ll notice that the chart appears in a separate container below the grid. When the application loads, a pre-defined chart is loaded along with the grid. Charts are also created on the fly when the user clicks on the buttons above the grid. To highlight the performance, 100 rows are randomly updated ten times a second.

Of course, this is just one example of what is possible through the new Charts API.

Charting | Video Preview

See the features and examples of our integrated Charts in the video preview above. The video runs through:

  • Charting Arbitrary Cell Ranges
  • Choosing Chart Types That Suit Your Data Best
  • Customizing appearance with Color Palettes
  • Creating Multiple Charts with their own Cell Ranges
  • Focusing on Particular Series w/Interactive Legends
  • Selecting which Categories and Series to Plot
Next Steps

This post announced the release of Integrated Charts, a major new feature available in ag-Grid Enterprise v21.

To get started using ag-Grid and Charts, go to ag-Grid and start using ag-Grid today. We would love to hear your feedback.

I hope this post has left you as excited as we are for the possibilities that Integrated Charts brings to your applications.

As always, comments and questions are welcome below.

Programming a Javascript Simon Game Tutorial

Programming a Javascript Simon Game Tutorial

In this javascript tutorial, I recorded myself live programming an html5 javascript simon game.

In this javascript tutorial, I recorded myself live programming an html5 javascript simon game.

For those who don't know, I'm a full stack web developer who has been in the industry for over 5 years now. There is a lot of things I have learned along the way and I'd like to share that knowledge with anyone wanting to learn!

like this video if you found it useful and would like to see more videos of the same content.

subscribe to my channel if you are trying to improve your abilities as a web developer, software engineer, or even if you are just learning to code.

Don't forget to turn on those bell notifications!

Understanding Memoization And Dynamic Programming in Javascript

Understanding Memoization And Dynamic Programming in Javascript

In this Javascript tutorial I will explain what memoization is, how to use it, when you should use memoization, how to use memoization, what dynamic programming is, how to use memoization in dynamic programming. Memoization is a big complicated word that you may have never even heard before, but you may be surprised to know that you are most likely already using memoization without even realizing it.

Memoization is a big complicated word that you may have never even heard before, but you may be surprised to know that you are most likely already using memoization without even realizing it. Memoization is just the act of caching values so that they can be calculated quicker in the future. Memoization is really useful in all parts of programming, but where it is most useful is in dynamic programming. In this video I will explain what memoization is, how to use it, and why it is so useful especially in dynamic programming.

🧠 Concepts Covered:

  • What memoization is
  • When you should use memoization
  • How to use memoization
  • What dynamic programming is
  • How to use memoization in dynamic programming

JavaScript Programming Tutorial - Full JavaScript Course for Beginners

JavaScript Programming Tutorial - Full JavaScript Course for Beginners

JavaScript is the programming language of HTML and the Web. JavaScript is easy to learn. This tutorial will teach you JavaScript from basic to advanced. JavaScript Programming Tutorial - Full JavaScript Course for Beginners

Watch this JavaScript tutorial for beginners to learn JavaScript programming from scratch. 👍

⭐️Course Contents⭐️

01 | Introduction

Get an introduction from Bob, as he kicks off the course, sets expectations, and gives you a little guidance for the road ahead.

02 | Setting Up the Development Environment

See how to install Node and Visual Studio Code, and learn why you need each. Watch as Bob writes a first tiny line of code to make sure that the installation is ready.

03 | Basic JavaScript Syntax

Hear about the basics of the JavaScript syntax, including how JavaScript is executed, how to create a properly formed statement, and more.

04 | Variables

Learn what variables are and how to declare, initialize, set, and get values from them.

05 | Data Types

JavaScript works with data types differently than other programming languages do. Learn from Bob as he explains some of the most basic data types and how to determine the type held by a variable.

06 | Type Coercion and Conversion

Sometimes you need to explicitly convert the data type of a value into a different data type. Sometimes JavaScript will do this automatically for you. Bob explains how and why this happens.

07 | Expressions and Operators

Learn how to spot a well-formed expression and how to compose expressions through the combination of operators and operands.

08 | Arrays

Watch as Bob demonstrates how to use arrays, how to add/remove elements of an array, how to access elements of an array using the index, how to get the number of elements in an array, and more.

09 | Function Declaration

Get an introduction to functions, as Bob shows you one way to define a function, how to call the function, how to pass parameters into a function, how to return values from a function, and more.

10 | Function Expressions

Sometimes a function declaration is more than you need. Get details in this lesson, as Bob demonstrates how to use a function expression and how to create an immediately invoked function expression.

11 | Decision Statements

Learn how to add logic to your applications by testing conditions using if / else statements, switch / case statements, and the ternary operator.

12 | Iteration Statements

Watch as Bob introduces the For and While statements, which enable you to loop through lists of values and perform operations on them.

13 | Basics of Scope

Hear an explanation of the notion of the lifetime of variables and their reach into other code blocks, in this discussion of scope.

14 | Returning Functions from Functions

As a building block toward a more sophisticated approach to building JavaScript applications, see how you can return functions from functions.

15 | Object Literals

Objects contain properties and functions that describe attributes of the object and its behavior, respectively. Watch as Bob demonstrates how to create object literals.

16 | Module Pattern and Revealing Module Pattern

Learn how to introduce variables and functions without leaving an unnecessarily large footprint on the global scope.

17 | Closures

Closures allow developers to bind functions to their execution context, including variables, so you can build specialized versions of functions. Learn how closures work and how to create them.

18 | this Keyword

Get the details on the "this" keyword, which causes a lot of confusion for JavaScript developers. Listen as Bob explains what this mysterious object is and how to bend it to your will.

19 | Destructuring

See how to use destructuring, a new feature in JavaScript that allows you to unpack array elements or object properties in a concise syntax.

20 | String Template Literals

Learn about the new string template literal syntax to enable string interpolation, multi-line string formatting, and more.

21 | Regular Expressions

Working with string data, Bob explains how use regular expressions to determine such things as whether a string matches a specific pattern or whether an instance of the pattern exists in a string.

22 | Built-In Natives

Join Bob as he examines native, built-in JavaScript functions that return objects that box the primitive types in order to provide additional helper methods on your values.

23 | Constructor Function Calls with the new Keyword

Learn how constructor functions work, see how to make key distinctions in what they are, and find out why they’re helpful.

24 | Objects and the Prototype Chain

Moving past the absolute beginner matter, listen in as Bob explains how objects work in JavaScript and how you can create an object that is linked to another object.

25 | JavaScript Classes

Bob demonstrates how “syntactic sugar” works on top of the existing functions and prototype chaining to help JavaScript resemble more traditional object-oriented programming languages.

26 | Arrow Functions

The latest version of JavaScript added arrow functions, a shorthand syntax for creating functions. Watch as Bob demonstrates how to create them and shows where they’re useful.

27 | Truthy and Falsy Values

Listen is as Bob circles back to topics that are important (but didn’t easily fit into earlier topics) and looks at the odd way in which JavaScript evaluates certain expressions as truthy and falsy.

28 | null Type

Similar to the undefined primitive type, the null type represents a variable that has no reference to an object when one was expected. Hear an explanation of how and why we should think about nulls.

29 | Date Objects

No discussion of JavaScript would be complete without understanding the Date built-in native function which provides properties and methods for working with dates and times.

30 | String Methods

The built-in native String function provides several very useful methods for manipulating and evaluating strings. Watch Bob demonstrate how to use a few of the most useful ones.

31 | Array Methods

We’ve worked with arrays throughout this course. Now Bob takes a few minutes to show you some of the most useful methods provided by the Array built-in native function.

32 | Error Handling with Try Catch

See how to wrap a try/catch/finally statement around potentially problematic code to anticipate everything that could go wrong with it, and learn other error-handling tips.

33 | Understanding the Document Object Model

Watch Bob examine the web browser environment and how it creates an object graph of nodes that represent elements, their attributes, and text, plus how to properly attach your code to an HTML page.

34 | Working with DOM Nodes

Continuing from the previous video, Bob demonstrates a slightly more compelling example that helps us understand how to manipulate, create, and delete element nodes and attribute nodes.

35 | Course Conclusion

In this final video, Bob briefly adds some closing comments and well wishes. You can also optionally complete a survey to provide insight into how Microsoft can improve this course.

Thanks for watching

If you liked this post, please do share/like it with all of your programming buddies!

Follow us on Facebook | Twitter