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

 

11 comments:

  1. 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. 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. Check out this guide on how to create a Gantt chart in Excel here

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

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. 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. 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. Just found https://pdfwordcounter.io/—a quick and effective way to count words in PDFs. Definitely bookmarking this!

    ReplyDelete
  9. 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
  10. Mobile App Development Services in Lahore – Build Smart, Scalable & User-Friendly Apps
    Need a powerful mobile app to grow your business or launch your startup? Our Mobile App Development Services in Lahore help you turn your ideas into fully functional Android and iOS apps with sleek design, smooth performance, and real-world impact.

    📱 What We Offer
    ✅ Android App Development
    We build native Android apps using Java, Kotlin, and Flutter for excellent performance, security, and scalability.

    ✅ iOS App Development
    Get elegant, high-performance iPhone and iPad apps built using Swift or React Native, optimized for all Apple devices.

    ✅ Cross-Platform App Development
    Want one app for both Android and iOS? We use Flutter and React Native to build cost-effective, fast apps from a single codebase.

    ✅ Custom App UI/UX Design
    We craft beautiful, intuitive app interfaces that offer a great user experience and keep users engaged.

    ✅ API & Backend Integration
    We develop secure, scalable backend systems and integrate your app with third-party APIs (payment gateways, GPS, CRMs, etc.).

    ✅ E-Commerce & Business Apps
    Launch a mobile store, booking app, food delivery service, or any business-specific app with smart features and user flows.

    ✅ App Testing & Deployment
    We ensure your app is bug-free, fast, and compatible with all devices. Then, we help publish it on Google Play Store and Apple App Store.

    ReplyDelete
  11. Encontré una calculadora de mi edad en horas que convierte tu fecha de nacimiento en cifras exactas, y fue más revelador de lo que imaginaba

    ReplyDelete