Create Bar Chart In Excel

This topic has been explained in great detail in the video shown below, to learn this topic just play the video and the notes are mentioned below the video.


Create Bar Chart In Excel






Create A Bar Chart in Excel

Using Microsoft Office Excel 2007, you can create a bar chart and give it a brand-new, appealing look. Much like a column chart, a bar chart is useful for comparing data points in one or more data series.

Formatted clustered horizontal cylinder chart

After you create a bar chart, you can change the spacing between the bars. You can also use a bar chart type to simulate a Gantt chart, a horizontal bar chart that is often used in project management programs.

 

Learn more about plotting data in a bar chart

Bar charts illustrate comparisons among individual items.

In bar charts, categories are organized along the vertical axis and values along the horizontal axis.

Bar chart in 3-D

Consider using a bar chart when:

  • You have one or more data series that you want to plot.
  • Your data contains positive, negative, and zero (0) values.
  • You want to compare the data for numerous categories.
  • The axis labels are long.
  • The values that are shown are durations.

When you create a bar chart, you can choose one of the following bar chart subtypes:

  • Clustered bar and clustered bar in 3-D    Clustered bar charts compare values across categories. In a clustered bar chart, the categories are typically organized along the vertical axis, and the values along the horizontal axis. A clustered bar in 3-D chart displays the horizontal rectangles in 3-D format; it does not display the data on three axes.Clustered bar and clustered bar charts in 3-D
  • Stacked bar and stacked bar in 3-D    Stacked bar charts show the relationship of individual items to the whole. A stacked bar in 3-D chart displays the horizontal rectangles in 3-D format; it does not display the data on three axes.Stacked bar and stacked bar charts in 3-D
  • 100% stacked bar and 100% stacked bar in 3-D    This type of chart compares the percentage that each value contributes to a total across categories. A 100% stacked bar in 3-D chart displays the horizontal rectangles in 3-D format; it does not display the data on three axes.100% stacked column and 100% column charts in 3-D
  • Horizontal cylinder, cone, and pyramid    These charts are available in the same clustered, stacked, and 100% stacked chart types that are provided for rectangular bar charts. They show and compare data exactly the same way. The only difference is that these chart types display cylinder, cone, and pyramid shapes instead of horizontal rectangles.Cylinder, cone, and pyramid bar charts

Top of Page

Create an elaborate bar chart

Formatted clustered horizontal cylinder chart

So, how did we create this bar chart? The following procedure will help you create a bar chart with similar results. For this chart, we used the example worksheet data. You can copy this data to your worksheet, or you can use your own data.

  1. Copy the example worksheet data into a blank worksheet, or open the worksheet that contains the data that you want to plot into a bar chart.How to copy the example worksheet data
    1. Create a blank workbook or worksheet.
    2. Select the example in the Help topic.

      NOTE: Do not select the row or column headers.

      Selecting an example from Help

      Selecting an example from Help
    3. Press CTRL+C.
    4. In the worksheet, select cell A1, and press CTRL+V.
1
2
3
4
5
6
7
8
9
10
A B
CITY, STAT E ANNUAL % AVG POSSIBLE SUNSHIN E
YUMA, AZ 90%
EL PASO, TX 84%
RENO, NV 79%
KEY WEST, FL 76%
HONOLULU, HI 71%
SAN FRANCISCO, CA 66%
NEW YORK, NY 58%
SEATTLE, WA 47%
JUNEAU, AK 30%
  1. Select the data that you want to plot in the bar chart.
  2. On the Insert tab, in the Charts group, click Bar.Excel Ribbon Image
  3. Under 2-D Bar, select Clustered Bar.
  4. Click the chart area of the chart.This displays the Chart Tools, adding the Design, Layout, and Format tabs.
  5. On the Design tab, in the Chart Styles group, click the chart style that you want to use.Excel Ribbon imageFor our bar chart, we used Style 4.
  6. In the chart, click the legend, and then press DELETE.
  7. To reduce the size of the chart title, right-click the title, and then select the size that you want in the Size box.For our bar chart, we used 12.
  8. To reduce the size of the axis labels, right-click the vertical (category) axis, and then select the size that you want in theSize box.For our bar chart, we used 8.
  9. Click the plot area of the chart, or select it from a list of chart elements (Layout tab, Current Selection group, Chart Elements box).
  10. On the Format tab, in the Shape Styles group, click the More button Button image , and then click the effect that you want to use.For our bar chart, we used the Subtle Effect – Accent 1.Shape Styles group on Excel Ribbon
  11. Click a data point to select all of the bars, or select the data series from a list of chart elements (Layout tab, Current Selection group, Chart Elements box).
  12. On the Format tab, in the Shape Styles group, click the More button Button image , and then click the effect that you want to use.For our bar chart, we used the Subtle Effect – Accent 2.
  13. On the Format tab, in the Shape Styles group, click Shape Effects.
  14. Click Glow, and then under Glow Variations, click the glow effect that you want.For our bar chart, we used the Accent color 2, 8 pt glow.
  15. Click the chart area of the chart.
  16. On the Format tab, in the Shape Styles group, click the More button Button image , and then click the effect that you want to use.For our bar chart, we used the Colored Outline – Accent 1.
  17. To change the size of the chart, on the Format tab, in the Size group, select the shape size that you want in the Shape Height box, and then press ENTER.For our bar chart, we used 4″.Outlook Ribbon Image
  18. If you want to use theme colors that are different from the default theme that is applied to your workbook, do the following:
    1. On the Page Layout tab, in the Themes group, click Themes.Excel Ribbon Image
    2. Under Built-in, click the theme that you want to use.For our bar chart, we used the Solstice theme.

Top of Page

Change the spacing between the bars

You can enlarge or reduce the space between the bars in a bar chart. In a 2-D bar chart, the bars can even overlap each other.

  1. In a chart, click the data series that you want to change, or do the following to select the data series from a list of chart elements:
    1. Click the chart.This displays the Chart Tools, adding the Design, Layout, and Format tabs.
    2. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click the data series.excel ribbon image
  2. TIP: You need to select only a single data series to change the spacing of all data series of the same chart type.

  3. On the Format tab, in the Current Selection group, click Format Selection.
  4. Under Series Options, do one of the following:
    1. To change the overlap of bars in a 2-D bar chart, drag the slider to the percentage of series overlap that you want, or enter a percentage between -100 and 100 in the Series Overlap box.

      TIP: The higher the value, the greater the overlap within the category.

    2. To change the spacing between categories of data markers in a 2-D or 3-D bar chart, drag the slider to the percentage of gap width that you want, or enter a value between 0 (zero) and 500 in the Gap Width box.

      TIP: The higher the value, the greater the spacing between the bars.

    3. To change the spacing between the data series in a 3-D bar chart, enter a value between 0 and 500 in the Gap Depthbox.

      TIP: The higher the value, the greater the distance between the bars.

Save a chart as a template

If you want to create another chart like the one that you just created, you can save the chart as a template that you can use as the basis for other similar charts.

  1. Click the chart that you want to save as a template.
  2. On the Design tab, in the Type group, click Save as Template.Excel Ribbon Image
  3. In the File name box, type a name for the template.

    TIP: Unless you specify a different folder, the template file (.crtx) will be saved in the Charts folder, and the template becomes available under Templates in both the Insert Chart dialog box (Insert tab, Charts group, Dialog Box Launcher Button image ) and the Change Chart Type dialog

The Video has been created by me to explain the topic and the Written information is as per a Microsoft” Excel Support  Post








Our Other Services




Read Free Ebooks

myeboook.com

Myebook has 1000's of free ebooks for you. On productivity, health, online income, learning, music and many more, it's free of course!



Buy Excel Course

myelesson.org/product

Become an Excel Guru, Buy the best Excel course. Learn on your mobile, tv & laptop without internet. For COD, Call 9752003788



Create Best Looking Resume

http://www.makecv.org/

At Makecv.org you get to create a amazingly professional looking resume in just 3 steps with our intuitive resume builder!


Download Excel Crash Course


This Excel Crash Course contains the list of topics that cover the most important and used features and formula of Excel . This Excel Crash Course lists 43 major topics in Excel so that you can start using Excel like a pro in the shortest possible time.



Learn Photoshop Web Designing


You can Buy the Photoshop Course to learn Photoshop and start a career in Web Designing and Photo Editing. .



Learn HTML CSS


You can Buy the HTML CSS Course to learn HTML CSS and start a career in Web Designing and Photo Editing. .


Download Full list of Excel Shortcuts


This Excel Shortcuts Complete list is to help you become save time and use Excel like a Master level user. Excel is best used when you know the Keyboard shortcuts because the use of keyboard shortcuts in Excel helps you in completing tasks faster.

I have created a Excel Shortcuts complete list for you to use Excel better, this list has 242 excel keyboard shortcuts which means that it covers almost everything that can be done using shortcuts in Excel.




Full List of Excel Formulas

This is a complete alphabetical list of all the Formula in Excel with a description. You can learn all these formulas on www.Myelesson.org




Convert Numbers to Text in Excel

Now easily convert numbers to Text in Excel with this inbuilt sheet from myelesson.org .  Many times we need the amount in figures to be converted into words. This is a typical requirement for writing checks or any other financial reports. Microsoft Excel does not have standard function available for this requirement. Just download this sheet and then you can convert any number to text in Excel.




List of Most Commonly Asked Excel Questions in Interviews

Here is the list of most asked excel related questions in interviews.  Prepare for this excel questions and you would be able to most of the excel interviews. This list of excel questions covers excel formula, excel analysis, excel reporting, excel charts and more.





Myelesson © 2010 - 2014. All rights reserved.

Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok
Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok