Chart with a lot of data

 

In this Article we will create charts with lots of data. We will start with the simple chart creation and then we will more to charts with large data in it.

Lets us start with creating simple data for a small chart:

large data set

Let's create a chart for these 10 products. Select this data and from insert select 2d column chart:

Insert column chart

 

This chart looks easy to understand. Now the problem arises if the number of products are large say 200 products. With 200 products the chart will look like this:

large data set column chart

It is not understandable so we can do some tricks to make it look better. First we can switch rows and columns in cart and will check the results:

switch rows and columns

Now the chart looks more understandable.

large data set column chart switched

 

We can also do more tricks like removing some months to say create quarterly charts.

quarterly charts

 

Similarly we can create pivot table to make the data more readable and create pivot charts for the same etc.: