Decision making is an important factor that forms part of all everyday business situations, whether the decisions are big or small they are still to be made. The bigger the risk involved in making a decision the more analysis goes in to preparing for an answer. With Excel’s logical expressions it is easy to represent data from over a period of time graphically with comparison charts.
When creating comparison charts with Excel to reflect two sets of data over a period of for example the video sales for the first six months of the year for 2005 and 2006, the most common graphs that are used are line graphs, bar graphs and column graphs.
Setting up the data you wish to graphically represent is the first step, for comparison charts you need to have two sets of data that you wish to compare. If we remain with the concept of video sales for the first six months of the year 2005 and 2006 your data would look something like this.
The data can also be entered into the spreadsheet in columns instead of rows. With the data as represented above you would be able to create comparison charts. To Initiate the Chart Wizard which is an Excel tool that assists in making comparison charts you highlight the cells that contain the data you would like to represent. Select Insert from the Excel toolbar and then charts.
A dialog box will appear, this is your Chart Wizard, this is the Excel tool that will facilitate the manufacturing of comparison charts. From the Chart type list select either the bar, column or line graph depending on the information that you would like to graphically represent. Remember when making a choice between bar and column comparison charts, the values on the bar graphs are always easier to interpret than those of the column graph. Click next to go to the next step, here you have to remember to tell the Wizard whether it should read the data in rows or columns, in the data example above the data would have to be read in rows. If you do not make the right selection your comparisons charts will be an incorrect graphical representation of the data you have inputed.
The third step is an important step as this is the step where you label the different parts of your comparison charts. These labels include:
Also you can label the data labels, ie give the different colors or lines depending on which of the comparison charts you chose, and then label the months on the X-axis.
Miricle Solutions is a company that is established to train companies to use the tools in Excel extensively to improve business solutions in your work place. Miricle Solutions can help you to master the art of comparison charts and other Excel tools.
Advanced Excel Course – June 2013 in South Africa Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 … Continue reading
A very popular chart is the waterfall chart which shows the impact of various items on a total e.g. the various components that explain the move from budgeted profit to actual profit. A common way to build this is using … Continue reading
"Adrian and Team. Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude towards De Wet, who hosted the Excel Advanced course.– Gill Robbetze Lonmin