sponsored ads

How to Make Column Chart or Bar Graph in Microsoft Excel

Topic:  Office, Excel, Microsoft Office  Product:  Microsoft Excel , Microsoft Office  Related Articles:  silinder column chart highcharts   colorset extjs column chart   column chart  

I need to create a excel chart for my boss this Friday to have a introduction for the company's production. I thought it was an easy thing because I have created ones before. However, he asked me to make a chart with 3-D effect. The reason is that this kind of chart can give audience strong impression. But I have no idea about this chart. Could someone tell me how to make a column chart or bar graph with 3-D effects in Microsoft Excel?

sponsored ads

Solution

  1. Launch your Excel and type your data into the cells. Then select all of them, including the row and column titles.
    Make Column Chart or Bar Graph in Microsoft Excel
  2. Then click "Insert" > "Charts" > "Column" > "3-D Column" in the ribbon.
    Make Column Chart or Bar Graph in Microsoft Excel
  3. Well, the basic column chart has been in the worksheet.
    Make Column Chart or Bar Graph in Microsoft Excel
  4. Go to "Chart Tools" in the ribbon and click "Design" tab. You will see many kinds of chart styles. Change one as you like.
    Make Column Chart or Bar Graph in Microsoft Excel
  5. Choose "Layout" tab under the "Chart Tools" in the ribbon.
    Make Column Chart or Bar Graph in Microsoft Excel
  6. Under this tab, you can click "Chart Title" to select one title to add to the column chart like this.
    Make Column Chart or Bar Graph in Microsoft Excel
  7. Then put the title name in the box and you will see the title is in the center of chart.
    Make Column Chart or Bar Graph in Microsoft Excel
  8. Also, click "Axis Titles" to add titles to two axises.
    Make Column Chart or Bar Graph in Microsoft Excel
  9. Well, titles have been done. In the "Layout" ribbon, you can do other things like axes settings, background settings, properties and so on.
    Make Column Chart or Bar Graph in Microsoft Excel
  10. Choose "Format" so that you can change shape styles, wordart styles, arrange setting, size and so on.
    Make Column Chart or Bar Graph in Microsoft Excel
  11. Now, you have made a column chart successfully.

Tips

See also

How to Create Line Graph in Microsoft Excel
How to Create an Advanced Graph in Microsoft Excel
How to Make a Pareto Chart in Microsoft Excel

How to Make Bar Graph with Stacked Bars in Microsoft Excel
Sometimes we need to make a stacked bar graph to show the data clearly, Of course the graph is much more better to demonstrate the problem, I know that the Excel have the function to do this, can you help me to do this, and can you help me to modify the tab?
How to Make a Pareto Chart in Microsoft Excel
My teacher gave me plenty of statistics and asked me to do with them for him. I'd better use the statistics to make a pareto chart, because this could explain a lot directly. But I am poor about software use. I am only able to use Microsoft Excel a little. I can deal with some data in Excel, but not create charts with data. Next week, my teacher will ask me for it, but I have not begun to do this job. Would someone like helping me?
How to Make Area Chart in Microsoft Excel
I work for my analysis report, and there are a lot of datum, so I find in order to display these datum I should make an area chart, but the problem is how to do that. I hope someone can help me.

Search for Related Topics

static column chart extjs   extjs column chart axis thick   conditional column chart extjs   mschart column chart gridlines front   extjs split column chart   bar graph   pengertian bar graph  

Related Unresolved Questions

more »
Options

Authors

Tagged Add my tag

chart , excel , multicolor column chart extjs4 , make2d column charts , column chart mathcad , differential column chart , extjs overlapping column chart

sponsored ads

Recent Searches

girls indian whitepants   farstone totalrecovery   ape cue cut   kad servers   gmail proxy   indir rundll32.exe   configuration desktop tumbleweed validator  

Download this software from AFC

Microsoft Excel Viewer 2003 1.0

Last Updated: Sep 10, 2008
License: Freeware
Filesize: 9.93MB

Continue to downloadPower by Afreecodec.com