ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

Creating Graphs in Microsoft Excel: Pie Charts, Bar Charts, and Histograms

Updated on October 2, 2014

Graphs in Microsoft Excel: An Introduction

Graphs are a particularly useful way to present data. To create graphs in Microsoft Excel, it is helpful to have already created a frequency distribution (since the format of your data in your frequency distribution is very similar to the format required to create a graph). For more on creating frequency distributions, check out this hub.

Although there are numerous graphs that can be created in Excel, I will cover three common types here: pie charts, bar charts, and histograms.

This guide will walk you through the step-by-step process of creating these basic graphs in Microsoft Excel. To illustrate how each graph is made, I will be using survey data extracted from the 2008 General Social Survey.

Format of data for a pie chart
Format of data for a pie chart

Pie Charts: A Good Way to Display Nominal-Level Data

Pie charts are typically used to display nominal-level data (although pie charts can be used to display ordinal-level data—it is more appropriate to display ordinal-level data in a bar chart). Pie charts are used only for qualitative variables, in other words, variables that are named. For more on levels of measurement, check out this hub.

To create a Pie Chart for a particular variable, list all values in a column in Microsoft Excel. In the column directly to the right of the list of values, enter corresponding frequencies. Information for a pie chart must be presented in the format presented on the right (although the number of values and corresponding frequencies will vary):

  • Ex. To create a pie chart for Highest Ranking (Symbols), we can re-use the information included in our frequency distribution (we have already done the work!). Select only the values and the frequencies (not the percentages, column headings, total, etc.). To select, click on cell C20, hold down your mouse, and drag over the adjacent data. Click on the “insert” tab in Microsoft Excel. Locate the button for “insert pie or doughnut chart” and select the particular type of chart you would like to use from the drop-down menu (I would recommend using the simple 2-D Pie). Once you make your selection, a pie chart with default settings will appear in your spreadsheet.

If you hover above the chart, three icons will appear to the right of it. These will allow you to modify your chart. The middle icon that looks like a paintbrush allows you to alter the “chart style.” For example, if we go to “chart styles” and select the third option down that appears, we can modify our Pie Chart to include percentages (results slightly differ from our frequency distribution due to Excel’s default rounding process). To edit the chart title double click on “Chart Title.” Charts can also be resized and moved within the spreadsheet.

Format of data for a bar graph
Format of data for a bar graph

Bar Charts: A Good Way to Display Ordinal-Level Data

Bar charts are used to display information on qualitative (nominal or ordinal-level) variables. In other words, they are useful for variables that are named, particularly those that are both named and ranked. To create a bar chart, data must be presented in the format depicted on the right (although the number of values and corresponding percentages) will vary.

If we have already created a histogram for the variable we are analyzing, we simply need to rearrange the information included in our frequency distribution so that the names of the values and the percentages are directly next to one another. It is best to manually re-enter information on percentages into a new block of cells (enter them in decimal form). Values may also be manually re-entered, but they may also be copied and pasted.

  • Ex. Let’s create a bar chart of “Highest degree completed” using the subsample of the GSS 2008 data. Using the existing frequency distribution for this data, re-enter information on values and their corresponding percentages in a new block of cells on the spreadsheet in the correct format. The original frequency distribution and the re-typed information for the bar chart directly below it are presented in the image below (on the left). Before proceeding to create a bar chart, highlight the percentages (in decimal form), and select the arrow next to the drop-down menu in the top center of the home tab (also depicted in the image below on the left). Once you have selected “percentages,” your data will display as a percentage (presented below in the image on the right). This must be done correctly in order to create a bar chart.

We can now create a bar chart. Click and hold down your mouse in cell B33 to select select the values and percentages in the reformatted table. Click on the “insert” tab and click on the button corresonding to “column chart.” I recommend selecting a basic 2-D column chart. Once you have made your selection, your default bar chart will appear in your spreadsheet. As with pie charts, the style of your bar chart can be modified and the title can be edited by double-clicking on it.

Histograms: A Good Way to Display Interval-Ratio Level Data

Histograms are used to display the distribution of quantitative variables graphically. Quantitative variables are often referred to as variables at the interval-ratio level of measurement, meaning they are characterized by numbers (rather than words). Histograms require data to be presented in the same format as for a pie chart (format displayed on the top right).

For example, to create a histogram for the variable age using the GSS 2008 subsample, it is first necessary to list all occurring values for age and their corresponding frequencies (as displayed on the bottom right).

To create the graph, highlight all values for age and their corresponding frequencies. In the “insert” tab, select the button denoting “column chart”. From the drop-down menu select “more column charts.” From the provided selections that open in a new window, choose the option for a “column chart” that presents frequencies as single bars. Once selected, this histogram will appear in the spreadsheet. As always, the style of the chart can be altered (ex. to make bars adjacent) and the title can be edited by double clicking on it.

Comments

    0 of 8192 characters used
    Post Comment

    • profile image

      kevin colt 

      3 years ago

      Instead of using MS excel we directly used charting library tools for creation of charts. Charting library like Google free chart, Koolchart etc.

      http://www.koolchart.com

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://hubpages.com/privacy-policy#gdpr

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)