Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
Good evening,
My workbook uses slicers and it covers multiple years, which is why you see three Septembers. There is no problem if I am selecting just one year. It is when I select multiple years I get the problem. In this workbook I have a pivot table displayed as bar graph. In the example I provided I have values 32, 32, and 26. However, the label wants to display the value as .032, .032, and .026. I am trying to adjust the number to get the who integer. I can use the "Value from Cells", but that will include all the cells whether it includes blank cells or subtotals which I don't want. I only want a whole number to be shown which will match the value of the particular in the graph. Bottom line how can I get the numbers as whole numbers.
Thank you
My workbook uses slicers and it covers multiple years, which is why you see three Septembers. There is no problem if I am selecting just one year. It is when I select multiple years I get the problem. In this workbook I have a pivot table displayed as bar graph. In the example I provided I have values 32, 32, and 26. However, the label wants to display the value as .032, .032, and .026. I am trying to adjust the number to get the who integer. I can use the "Value from Cells", but that will include all the cells whether it includes blank cells or subtotals which I don't want. I only want a whole number to be shown which will match the value of the particular in the graph. Bottom line how can I get the numbers as whole numbers.
Thank you