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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks