When making Marketing Plan one of the activities being carried out is the analysis of competition. How strong is our competition? There are several ways to find this out, and this is perhaps most easily accomplished by tracking revenue and profit of competitors over several years. The following text will show you several Excel charts which should show where is our company and where are competitors on the market.
There is a time of Christmas holidays, the time when everybody, more or less, decorates the Christmas tree, and this served as an inspiration for the text on the application of one more type of Excel chart. It is a subtype of the Scatter called Bubble and by which we can get a “XY” chart whereby a multicolored “balls” are found on the section. To create this diagram all we need are: a table of data, a picture of the Christmas tree and a little work in Excel!
It’s not too difficult to create a chart, but you need to choose the type that best reflects our data. Excel has a multitude of charts, and every one of them suits best certain types of data. In the text that follows you will meet most commonly used charts, with suggestions on how to choose the right one that will meet your needs.