In this session we're going to look at how to select data and we're going to use column charts. As an example : specifically clustered column charts as we've seen Alt f1 will quickly create a column chart. If i just delete that, there are other ways to create a chart with this area selected. Using Control A we can go to insert and then we can go to recommended charts. Excel gives us a choice of the charts that he thinks we're most likely to want to use. We could also go to all charts and see all the charts that we have available.
How To Use Column Charts ? As i said this is a clustered column. It's ideal if we've got two or more rows of data and two or more columns of data. Add some more data here, if i want to incorporate this additional data in a chart i would just set the first range of data and then hold Ctrl key down and select second range of data. Again Alt f1 and this time we get a clustered column chart. This context clustered means that, the categories are grouped together.
Edit The Chart Range
So, for t we've got the two years grouped together coffee we've got two years to group together and so, to come out there and delete that chart selecting this data to the left again. If i want to edit the chart range, i have a couple of options. One i could literally just highlight this data Control C. Click over the chart Control V and the data is added to the chart. Undo that another option would be to right click and go select data .If the data was contiguous, i could go to short data range and just edit that from C to D but it's not. So, I need to go down to legend entries and click on add series name and series values.
Firstly, hit the Delete key to get rid of the series values and then highlight the data that we want to add okay. We achieve the same thing cancel out there another way to do. Exactly the same thing is to go to chart design and select data brings up the same dialog box. So, cancel out of there just adding this data for cells 18 back with Ctrl C and Ctrl V .Again this chart is great when we've got two or more rows of data and two or more columns of data.
How To Use Column Charts Use direct comparisons between comparable data
How To Use Column Charts ? We want to make direct comparisons between comparable data. So, For example: We can see how t cells have compared from one year to another to make this chart bigger. If we want to change the look and feel of the chart let's just go to chart design. Firstly, one option we have is quick layout here we can see various different configurations of the same chart. So, if i hover over them we'll see. For example: This one brings in data labels and a legend. This one brings in a data table below the chart and this one overlays one of the bars partly over the other bar.
Go To Chart Style
So, on then i can go to chart styles. We have quite a range here. So, i can really sort of change the look and feel of the style of the chart. If we want to refine the chart type we've also got change chart type up in the ribbon. We have the various different types of column. We could go for stacked column perhaps instead of a clustered column for this particular set of data. This is perhaps a little bit harder to read but it's worth knowing about and we also have move chart. If we want to relocate this chart.
when we create a chart set the chart up if we want to make some quick and easy changes to the chart. Go to this green plus to get the chart elements. For example: Maybe, we would like a data table. Then we can see all the data for the two years immediately below the chart. It's quite useful if you can see the data visually in a place that's adjacent to or otherwise very close to the graphical representation. i.e the var of course the other way to do that is with data labels. Although sometimes data labels can be quite crowded and you may need to play around with the settings.
How To Use Column Charts Experiment The Variations
The color of the font of the label contrasts the color of the background of the bar on which it's sitting on top or you may want to relocate. The labels we also have legend .So, we can see the legend here legends are quite useful. Quite well understood sometimes though the legend can be a little bit too far away, from the graphic that it's related that it's relating to so, visually the eye has to track the legend and then track back to the graphic and of course. If we don't want to try all of these customization. We can just go to quick layout and experiment with all kinds of variations thank you.