Understanding Column Charts In Microsoft Office Excel 2007
MS Office Excel 2007 is a powerful and complex piece os software. However, it also contains a number of easy-to-use and time-saving features. In this tutorial will look at the creation and customisation of a column chart. The first step is to select the data that we want to plot, taking care to include any column and row headings. Row headings will be used as the names of the chart series and will be displayed in the legend. Column headings will be used as category labels. If the selection includes two sets of column headings, Excel will automatically recognize this and create two sets of headings on the category axis for us.
The next step is to click on the Insert ribbon tab and from the Column drop-down menu choose the option that we require. The very first option is the omnipresent scattered column chart. Excel creates our chart and places it in the worksheet as an embedded chart. If we want to change it to a standalone chart, click on Move Chart in the Location section and then choose New Sheet and enter a name for the new chart sheet.
Having selected a chart, you can of course customise it to suit your requirements. To change the colour of the columns, simply click once on any column to highlight the whole series and then choose a colour from the Shape Fill drop-down menu in the Format contextual tab. As well as Shape Fill, the drop-down also offers Shape Outline and Fill Effects. The Fill Effects includes preset effects such as shadow, glow and bevel.
There are quite a few subtypes available within the column chart type. The most basic and probably the most widely used is the clustered column chart type. To change the chart type, go to the Design contextual tab and click on Change Chart Type.
In the Stacked Column type, the overall total of all series within each category takes precedence over the individual value associated with each series. The second type of stacked column is 100% Stacked Column. Here, the height of each column becomes 100% and so all columns have exactly the same height. This type of chart shifts the emphasis away from the number or quantity represented by each series to the percentage split between series.
Excel also offers 3-D versions of its three different column chart types. You will notice that these chart tpes are not strictly 3-D charts; they simply have a 3-D effect on the columns. It is the 3-D Column option which gives us an actual three-dimensional chart. Here, Excel adds depth to the chart and places the series along the z axis (the third dimension). The remaining column options are simply variations on these basic themes. For example, if we want to go for a 3-D chart, we might choose to have pyramids instead of rectangular blocks.
Need to master Microsoft Excel 2007. We offer Microsoft Excel tuition in London and all over the UK.
Related Reading:
Norton Internet Security 2010 1-User/3PCNorton Internet Security 2010 delivers fast and light comprehensive online threat protection. It guards your PC, network, online activities and your i... Read More >
Sound Forge Audio Studio 9Sony Sound Forge Audio Studio 9 Sound Forge Audio Studio software is everything you need to edit and master professional-quality audio on your home co... Read More >
Microsoft Windows 7 Home Premium UpgradeIf you're already running XP or Vista, you probably know some of the many benefits of being a Windows user. Now, with the Upgrade Version of the lates... Read More >
Microsoft Outlook 2007Office Outlook 2007 provides an integrated solution for managing your time and information, connecting across boundaries, and remaining in control ... Read More >
Anime Studio Debut 6Complete Animation for Digital Artists: The fun, quick and affordable way to create animations, Anime Studio is the ideal solution for first time anim... Read More >
Popularity: 1% [?]
.gif)
.jpg "Free Traffic System - Increase Targeted Website Traffic with Free
Unlimited One Way Links")
