Bar+Chart

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 (data points: Individual values plotted in a chart and represented by bars, columns, lines, pie or doughnut slices, dots, and various other shapes called data markers. Data markers of the same color constitute a data series.) in one or more data series  (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.). 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. In this article
 * [|Learn more about plotting data in a bar chart]
 * [|Create an elaborate bar chart]
 * [|Change the spacing between the bars]
 * [|Simulate a Gantt chart]
 * [|Save a chart as a template]

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. 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: [|Top of Page]
 * **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. [[image:http://office.microsoft.com/global/images/default.aspx?AssetID=ZA102249001033 caption="Clustered bar and clustered bar in 3-D charts"]]
 * **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. [[image:http://office.microsoft.com/global/images/default.aspx?AssetID=ZA102249011033 caption="Stacked bar and stacked bar in 3-D charts"]]
 * **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. [[image:http://office.microsoft.com/global/images/default.aspx?AssetID=ZA102248961033 caption="100% stacked bar and 100% stacked bar in 3-D charts"]]
 * **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. [[image:http://office.microsoft.com/global/images/default.aspx?AssetID=ZA102248971033 caption="Cylinder, cone, and pyramid charts"]]

Create an elaborate bar 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. How to copy the example worksheet data Selecting an example from Help
 * 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.
 * 1) Create a blank workbook or worksheet.
 * 2) Select the example in the Help topic.
 * Note** Do not select the row or column headers.
 * 1) Press CTRL+C.
 * 2) In the worksheet, select cell A1, and press CTRL+V.

> ||~ A ||~ B || > 1 || **CITY, STATE** || **ANNUAL % AVG POSSIBLE SUNSHINE** || > 2 || YUMA, AZ || 90% || > 3 || EL PASO, TX || 84% || > 4 || RENO, NV || 79% || > 5 || KEY WEST, FL || 76% || > 6 || HONOLULU, HI || 71% || > 7 || SAN FRANCISCO, CA || 66% || > 8 || NEW YORK, NY || 58% || > 9 || SEATTLE, WA || 47% || > 10|| JUNEAU, AK || 30% || This displays the **Chart Tools**, adding the **Design**, **Layout**, and **Format** tabs. [|Top of Page]
 * 1) Select the data that you want to plot in the bar chart.
 * 2) On the **Insert** tab, in the **Charts** group, click **Bar**. [[image:http://office.microsoft.com/global/images/default.aspx?AssetID=ZA101654341033 caption="Charts group on Excel Ribbon"]]
 * 3) Under **2-D Bar**, select **Clustered Bar**.
 * 4) Click the chart area  (chart area: The entire chart and all its elements.) of the chart.
 * 1) On the **Design** tab, in the **Chart Styles** group, click the chart style that you want to use. [[image:http://office.microsoft.com/global/images/default.aspx?AssetID=ZA102248981033 caption="Chart Styles on Excel Ribbon"]]
 * Tip** For our bar chart, we used **Style 4**.
 * 1) In the chart, click the legend, and then press DELETE.
 * 2) To reduce the size of the chart title, right-click the title, and then select the size that you want in the **Size** box.
 * Tip** For our bar chart, we used **12**.
 * 1) To reduce the size of the axis labels, right-click the vertical (category) axis, and then select the size that you want in the **Size** box.
 * Tip** For our bar chart, we used **8**.
 * 1) Click the plot area  (plot area: In a 2-D chart, the area bounded by the axes, including all data series. In a 3-D chart, the area bounded by the axes, including the data series, category names, tick-mark labels, and axis titles.) of the chart, or select it from a list of chart elements (**Layout** tab, **Current Selection** group, **Chart Elements** box).
 * 2) On the **Format** tab, in the **Shape Styles** group, click the **More** button [[image:http://office.microsoft.com/global/images/default.aspx?AssetID=ZA100868781033 caption="Button image"]], and then click the effect that you want to use.
 * Tip** For our bar chart, we used the **Subtle Effect - Accent 1**.
 * 1) Click a data point  (data points: Individual values plotted in a chart and represented by bars, columns, lines, pie or doughnut slices, dots, and various other shapes called data markers. Data markers of the same color constitute a data series.) to select all of the bars, or select the data series  (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.) from a list of chart elements (**Layout** tab, **Current Selection** group, **Chart Elements** box).
 * 2) On the **Format** tab, in the **Shape Styles** group, click the **More** button [[image:http://office.microsoft.com/global/images/default.aspx?AssetID=ZA100868781033 caption="Button image"]], and then click the effect that you want to use.
 * Tip** For our bar chart, we used the **Subtle Effect - Accent 2**.
 * 1) On the **Format** tab, in the **Shape Styles** group, click **Shape Effects**.
 * 2) Click **Glow**, and then under **Glow Variations**, click the glow effect that you want.
 * Tip** For our bar chart, we used the **Accent color 2, 8 pt glow**.
 * 1) Click the chart area of the chart.
 * 2) On the **Format** tab, in the **Shape Styles** group, click the **More** button [[image:http://office.microsoft.com/global/images/default.aspx?AssetID=ZA100868781033 caption="Button image"]], and then click the effect that you want to use.
 * Tip** For our bar chart, we used the **Colored Outline - Accent 1**.
 * 1) 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.
 * Tip** For our bar chart, we used **4"**.
 * 1) If you want to use theme colors that are different from the default theme that is applied to your workbook, do the following:
 * 2) On the **Page Layout** tab, in the **Themes** group, click **Themes**. [[image:http://office.microsoft.com/global/images/default.aspx?AssetID=ZA101654451033 caption="Themes group on Excel Ribbon"]]
 * 3) Under **Built-in**, click the theme that you want to use.
 * Tip** For our bar chart, we used the **Solstice** theme.

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. This displays the **Chart Tools**, adding the **Design**, **Layout**, and **Format** tabs. [|Top of Page]
 * 1) In a chart, click the data series  (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.) that you want to change, or do the following to select the data series from a list of chart elements:
 * 2) Click the chart.
 * 1) On the **Format** tab, in the **Current Selection** group, click the arrow next to the **Chart Elements** box, and then click the data series. [[image:http://office.microsoft.com/global/images/default.aspx?AssetID=ZA101940491033 caption="Current Selection group on Excel Ribbon"]]
 * Tip** You need to select only a single data series to change the spacing of all data series of the same chart type.
 * 1) On the **Format** tab, in the **Current Selection** group, click **Format Selection**.
 * 2) Under **Series Options**, do one of the following:
 * 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.
 * 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.
 * To change the spacing between the data series in a 3-D bar chart, enter a value between 0 and 500 in the **Gap Depth** box.
 * Tip** The higher the value, the greater the distance between the bars.

Simulate a Gantt chart
Even though Excel does not provide a Gantt chart type, you can simulate a Gantt chart by customizing the stacked bar chart type so that it depicts tasks, task duration, and hierarchy. The following procedure will help you create a Gantt chart with results that are similar to those shown in the preceding graphic. For this chart, we used the example worksheet data. You can copy this data to your worksheet, or you can use your own data, as long as you use the same column headers and worksheet structure. How to copy the example worksheet data Selecting an example from Help
 * 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 Gantt chart.
 * 1) Create a blank workbook or worksheet.
 * 2) Select the example in the Help topic.
 * Note** Do not select the row or column headers.
 * 1) Press CTRL+C.
 * 2) In the worksheet, select cell A1, and press CTRL+V.

> ||~ 1 || > ||~ 2 || > ||~ 3 || > ||~ 4 || > ||~ 5 || > ||~ 6 || || ||~ A ||~ B ||~ C || > || **Task** || **Start** || **Duration** || > || Task 1 || 0 || 2 || > || Task 2 || 2 || 6 || > || Task 3 || 8 || 9 || > || Task 4 || 17 || 3 || > || Task 5 || 20 || 5 || || [|Top of Page]
 * Note** The values in columns B and C (**Start** and **Duration**) represent the number of days from the start date and the number of days required to complete the task.
 * 1) Select the data that you want to plot in the Gantt chart (A1:C6 in our example worksheet data).
 * 2) On the **Insert** tab, in the **Charts** group, click **Bar**.
 * 3) Under **2-D Bar**, click **Stacked Bar**.
 * 4) In the chart, click the first data series, or select it from a list of chart elements (**Format** tab, **Current Selection** group, **Chart Elements** box).
 * 5) On the **Format** tab, in the **Current Selection** group, click **Format Selection**. [[image:http://office.microsoft.com/global/images/default.aspx?AssetID=ZA101940491033 caption="Current Selection group on Excel Ribbon"]]
 * 6) Click **Fill**, and then click **No fill**.
 * 7) Click **Close**.
 * 8) On the chart, click the legend, and then press DELETE.
 * 9) Select the vertical (value) axis, or select it from a list of chart elements (**Format** tab, **Current Selection** group, **Chart Elements** box).
 * 10) On the **Format** tab, in the **Current Selection** group, click **Format Selection**.
 * 11) Under **Axis Options**, select the **Categories in reverse order** check box.

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. For more information about how to apply a chart template, see [|Create, apply, or remove a chart template]. [|Top of Page] See Also [|Printer-Friendly Version] Original page: []  © 2010 Microsoft Corporation. All rights reserved.
 * 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**. [[image:http://office.microsoft.com/global/images/default.aspx?AssetID=ZA101653891033 caption="Type group on Excel Ribbon"]]
 * 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 [[image:http://office.microsoft.com/global/images/default.aspx?AssetID=ZA100985101033 caption="Button image"]]) and the **Change Chart Type** dialog box (**Design** tab, **Type** group, **Change Chart Type**).
 * Note** A chart template contains chart formatting and stores the colors that are in use when you save the chart as a template. When you use a chart template to create a chart in another workbook, the new chart uses the colors of the chart template — not the colors of the document theme that is currently applied to the workbook. To use the document theme colors instead of the chart template colors, right-click the chart area (chart area: The entire chart and all its elements.), and then click **Reset to Match Style** on the shortcut menu.
 * [|Available chart types]
 * [|Change the format of chart elements]
 * [|Change the layout or style of a chart]
 * [|Change the shape fill, outline, or effects of chart elements]
 * [|Create a chart]
 * [|Print a chart]
 * [|The Project Map: Your road map to project management]