Microsoft excel 2007 chart tutorial
![microsoft excel 2007 chart tutorial microsoft excel 2007 chart tutorial](https://s3.studylib.net/store/data/005867032_2-03500cb85c9a47ae9657b210f6ce1ccc-768x994.png)
Repeat these last steps to all of the series of data. There is one last step to complete the chart.Įvery data point needs a border to better differentiate it from the others.įrom the Chart Tools's Format tab, select Shape Outline. The next step consists of removing the space between the data bars. Select the vertical axis (0-15, 16-30 …) that is on the right side of the chart. The next steps consist on moving it to the left of the chart. Except that, the vertical axis is in the middle of the chart. The next step is to regroup all these values on to a single axis.Īll the data will realign according the axis below the chart. Learn about Excel functions and the powerful features Excel has to offer to analyze data. At this point, the male data is on the right of the chart and the female data is on the left. If you're an Excel beginner, this is the perfect place to start. The last commands were necessary to align both series of data.
![microsoft excel 2007 chart tutorial microsoft excel 2007 chart tutorial](http://innov8tiv.com/wp-content/uploads/2015/07/make-charts-in-excel-8.jpg)
Select any of the series of data within the chart.įrom the Chart Tools' Layout or Format tabs, select Format selection.įrom the Series options category, select the Secondary axis option. There are still a few more steps to go through before the final result. However, the negative values will appear to the left of the center (zero value) and the positive values to the right of the zero valueįrom the Insert tab, select Bar and Clustered bar options.Īs you can see, the chart is not yet completed. All the values in one of the data ranges must be positive and the other negative. In this case, there is one column of data for male and another for females.
#Microsoft excel 2007 chart tutorial how to
This page will show you how to do it step by step.Įnter the text and numbers in the appropriate cells.
![microsoft excel 2007 chart tutorial microsoft excel 2007 chart tutorial](https://i.ytimg.com/vi/kFK9DBaJRRM/maxresdefault.jpg)
You must have seen a demographics chart like the one above and wondered how to make your own.