A few days ago, I updated such a chart that shows typical bar graphs and line would also go up the bars representing some other trend related, well inserting data was easy for me. I thought I could also create the same graph myself. Unsuccessful effort! Luckily my colleague showed me how. A million thanks to Kristine, I will share her advice here. So, just follow steps below in order to create a bar-line combination graph on MS Excel 2007.
1. Select data
2. Create a 'bar' chart
3. go to: chart tools/layout/chart area - here scroll down to choose a series [that you want to make a line/ or show a trend line:)] Once you choose, you will see highlighted dots on the bar which they represent the series. There, just click right on data set: then select format/data series ~choose 'secondary axis' plot
4. Now go to 'insert' menu tab and choose a line chart!
That is it. You will see nice a graph like this one.
No comments:
Post a Comment