+ Reply to Thread
Results 1 to 2 of 2

Pie chart to display single cell data

  1. #1
    Registered User
    Join Date
    08-15-2016
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    5

    Pie chart to display single cell data

    Hi, I have 3 cells that display a percentage and want to use those 3 cells as the data for my pie chart as example below.

    http://www.excelforum.com/attachment...1&d=1475171361
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2013
    Posts
    142

    Re: Pie chart to display single cell data

    Go to Insert --> Pie Chart
    Select the style of pie chart you want to use

    Under Chart Tools --> Design click on Select Data

    Click inside the "Chart data range" box
    Highlight cells B1 through D1 hold down the Ctrl key and highlight B3 through D3
    Click "OK"

    Under Chart Tools --> Layout click on Data Labels. Chose the location on the pie chart you'd like to labels (percentages) to appear.

    Done

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 09-13-2016, 10:43 AM
  2. [SOLVED] Best Way to Display a Large Amount of Data in a Single Cell
    By daedelous00 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-18-2013, 11:58 AM
  3. Display data from multiple cell in a single cell, based on criteria
    By Mothman in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-08-2012, 07:24 AM
  4. Replies: 1
    Last Post: 07-14-2012, 11:46 AM
  5. Display two columns of data in single cell
    By wolverinej in forum Excel General
    Replies: 0
    Last Post: 02-21-2011, 11:42 PM
  6. Display message for single bar in bar chart
    By maacmaac in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-18-2009, 05:16 AM
  7. [SOLVED] Excel 2000: Can I display more than one curve in a single chart
    By Avraham Makeler in forum Excel General
    Replies: 1
    Last Post: 04-19-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1