Tuesday, May 27, 2014

Creating a Bar Chart in 7 Steps in Excel 2010 and Excel 2013

Creating a Bar Chart in 7

Steps in Excel

Only three types of Excel charts are presented in this blog. They are the area chart, the bar chart, and the scatterplot. There are, of course, many types of charts available in Excel and many variations of each type. This chapter will provide instructions on creating both the scatterplot and bar chart in Excel. Instructions to create an interactive area chart of a statistical distribution are presented at the beginning of the final chapter of this manual which covers graphing statistical distributions in Excel.

A bar chart is a chart with rectangular bars with lengths proportional to the values that they represent. Bars can be single, grouped, or stacked. Bar can be horizontal or vertical. This section will discuss how to create a bar chart that presents single, vertical bars. Single bars present the value of one variable that is associated with each data observation.

In this example this following bar chart will be created from the X-Y data in cells I4 to J8.

excel, excel 2010, excel 2013, bar chart, chart graph, excel chart, excel graph(Click Image To See a Larger Version)

 

Bar Chart Step 1 –

Highlight the Y Data

Select the data in cells J4 to J8.

excel, excel 2010, excel 2013, bar chart, chart graph, excel chart, excel graph

 

Bar Chart Step 2 –

Select Chart Type

Make the following selections:

Insert tab / Column / 2-D Clustered Column

excel, excel 2010, excel 2013, bar chart, chart graph, excel chart, excel graph(Click Image To See a Larger Version)

This produces the following basic bar chart:

excel, excel 2010, excel 2013, bar chart, chart graph, excel chart, excel graph(Click Image To See a Larger Version)

 

Bar Chart Step 3 –

Insert X-Axis Data

Right-click anywhere in the chart and choose Select Data as follows:

excel, excel 2010, excel 2013, bar chart, chart graph, excel chart, excel graph(Click Image To See a Larger Version)

This brings up the following dialogue box. Under the label Horizontal (Category) Axis Labels on the right side, select the Edit button.

excel, excel 2010, excel 2013, bar chart, chart graph, excel chart, excel graph(Click Image To See a Larger Version)

This brings up a blank Axis Labels dialogue box as follows:

excel, excel 2010, excel 2013, bar chart, chart graph, excel chart, excel graph(Click Image To See a Larger Version)

Select the X-Axis data in cells I4 to I8 as follows:

excel, excel 2010, excel 2013, bar chart, chart graph, excel chart, excel graph(Click Image To See a Larger Version)

This produces the following labels for the X-Axis:

excel, excel 2010, excel 2013, bar chart, chart graph, excel chart, excel graph(Click Image To See a Larger Version)

Format these labels by right-clicking on the X-Axis, select Bold, and then set the font size in the cell font dialogue box as follows:

excel, excel 2010, excel 2013, bar chart, chart graph, excel chart, excel graph(Click Image To See a Larger Version)

This produces the following X-Axis:

excel, excel 2010, excel 2013, bar chart, chart graph, excel chart, excel graph(Click Image To See a Larger Version)

 

Bar Chart Step 4 –

Delete the Legend

Select the legend and delete it.

excel, excel 2010, excel 2013, bar chart, chart graph, excel chart, excel graph(Click Image To See a Larger Version)

 

Bar Chart Step 5 –

Insert Chart Title

Click anywhere on the chart to bring up the Chart Tools menu. Choose the Layout tab / Chart Title / Above Chart as follows:

excel, excel 2010, excel 2013, bar chart, chart graph, excel chart, excel graph(Click Image To See a Larger Version)

This creates up the following basic chart title:

excel, excel 2010, excel 2013, bar chart, chart graph, excel chart, excel graph(Click Image To See a Larger Version)

Highlight the text and type in the correct title as follows:

excel, excel 2010, excel 2013, bar chart, chart graph, excel chart, excel graph(Click Image To See a Larger Version)

 

Bar Chart Step 6 –

Insert X-Axis Label

Right-click anywhere on the chart to bring up the Chart Tools menu. Choose Layout tab / Axis Titles / Primary Horizontal Axis / Title Below Axis as follows:

excel, excel 2010, excel 2013, bar chart, chart graph, excel chart, excel graph(Click Image To See a Larger Version)

Highlight the basic X-Axis label that appears. Type in the correct X-Axis text, select Bold, and select the correct font size as follows:

excel, excel 2010, excel 2013, bar chart, chart graph, excel chart, excel graph(Click Image To See a Larger Version)

 

Bar Chart Step 7 –

Insert Y-Axis Label

Right-click anywhere on the chart to bring up the Chart Tools menu. Choose Layout tab / Axis Titles / Primary Vertical Axis / Horizontal Title as follows:

excel, excel 2010, excel 2013, bar chart, chart graph, excel chart, excel graph(Click Image To See a Larger Version)

After correcting the Y-Axis label by typing in the correct text, making it Bold, and setting the correct font size as was just done for the X-Axis label, the final bar graph will appear as follows:

excel, excel 2010, excel 2013, bar chart, chart graph, excel chart, excel graph(Click Image To See a Larger Version)

 

Excel Master Series Blog Directory

Statistical Topics and Articles In Each Topic

 

Posted by at

9 comments:

  1. Lauren RoseJuly 5, 2021 at 3:05 AM

    Pro Dissertation Writing can help you out with Medical Dissertation Writing Services. Healthcare sector concentrate more on practices than the theoretical approaches, while that makes writing quite difficult for medical student.

    ReplyDelete
  2. UnknownSeptember 18, 2021 at 2:47 PM

    Great stuff! Here's another guide where you can learn how to create a Gantt chart in Excel: https://spreadsheetdaddy.com/charts/gantt

    ReplyDelete
  3. UnknownSeptember 18, 2021 at 2:49 PM

    Check out this guide on how to create a Gantt chart in Excel here

    ReplyDelete
  4. Angel17June 17, 2023 at 8:11 AM

    Is it hard to make that one? Thanks for sharing it! basement refinishing near me

    ReplyDelete
  5. erikafrommMay 22, 2024 at 8:18 AM

    This comment has been removed by the author.

    ReplyDelete
  6. Astroport GlobalJune 24, 2024 at 12:02 AM

    Immerse yourself in the distinctive hospitality of Karnataka by choosing from the wide array of hotels that showcase the state's unique cultural heritage. Whether you're looking to delve into the rich history of the region or explore its picturesque landscapes, the hotels in Karnataka provide a perfect base for your adventures.

    Several hotels in Karnataka are strategically located, offering breathtaking views of the lush greenery, mist-clad mountains, or vibrant cityscapes. This allows guests to wake up to mesmerizing vistas, filling their days with a sense of tranquility and awe. Additionally, many of these hotels also organize nature walks or guided tours, providing visitors with opportunities to explore the diverse flora and fauna of the region.

    ReplyDelete
  7. Phone Number GeneratorAugust 12, 2024 at 12:50 AM

    If you're looking for a way to cherish and remember the special moments in your relationship, the Relationship Tracker Online is a great choice. It allows you to easily log important dates, milestones, and memories, giving you a beautiful overview of your journey together.

    ReplyDelete
  8. Wedding Photographer in Hudson ValleyFebruary 15, 2025 at 1:35 PM

    Just found https://pdfwordcounter.io/—a quick and effective way to count words in PDFs. Definitely bookmarking this!

    ReplyDelete
  9. Phone Number GeneratorApril 7, 2025 at 12:07 PM

    Estoy preparando mi boda, y esta herramienta ha sido una aliada esencial. Desde saber cuántos días faltan hasta organizar el cronograma con proveedores, todo lo planeo mejor gracias a esta simple función. Incluso la compartí con mi pareja y ahora la usamos juntos. www.calculadoradedias.com

    ReplyDelete

Subscribe to: Post Comments (Atom)