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:Let’s create a chart for these 10 products. Select this data and from insert select 2d 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:
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:
Now the chart looks more understandable.
We can also do more tricks like removing some months to say create quarterly charts.
Similarly we can create pivot table to make the data more readable and create pivot charts for the same etc.: