integer for pie chart

freeriding

New Member
Joined
Sep 21, 2015
Messages
18
i have a pie chart, where in the ''data labels'' i have activated the below:


How do i set it, so the value in the pie chart has no decimal digits? (the table that provides the values in the pie chart has values with decimals, and would not like to change it)



 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
10,997
make a duplicate table with integer values and use that for the pie chart
 

Watch MrExcel Video

Forum statistics

Threads
1,099,082
Messages
5,466,537
Members
406,485
Latest member
kaksolver

This Week's Hot Topics

Top