Sometimes you need a couple of Arrows!!
When we build our Graph sometimes it is useful to explain a variation and correlate the variation with some events that occurred. Let's see one example where we use arrows to pinpoint specific events and root cause of the variation👍

Sometimes you need a couple of Comments!!
Comments are really useful to improve the readability of your Graph. Let's see how to add few comments to our Pie Chart

Pie Chart in Python

An example of a pie chart using Python

Using List comprehensions in Python
List comprehensions are a concise and readable way to create lists. This is a great tool to use to set the X Ticks and Y Ticks of the Chart.
Here an example for the Stacked Area Chart we created previously 👍

This time we look at a Stacked Area Chart.

To make a Stacked Area Chart you need to use StackPlot

Here a small example.😀

Stacked Bar: Sometimes you have a dataframe but you dont need to see all the columns stacked but just few of them.

In this case you can use to_numpy() method to convert the series or dataframe slice into a numpy array. Then you can stack the column that you need as shown below.👍

Example of Stacked Bar Chart in Excel using Python👍

Refine Graph with Scale and gridlines.
In this post we take a look at how to refine the scale of the graph using "ylim" on the plt object.
Then we build a small array with the values of ticks to pass to the graph to set the ticks on vertical axis

Format the Title=> Let's create a specific line for the title by adding "set_title" to our graph object.
Use "fontdict" to format size,style,weight and color.
Add a "bbox" to format further title's facecolor, the boxstyle as round with pad equal to 0.2 and edgecolor.😉

Pandas in Microsoft Excel. Using Python in Excel is something very useful when you are doing data analysis

Here a simple bar chat:

First let's create a dataframe in Excel called "t"

Then we can generate a bar chart with the code👍