• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

Rounding Down Data Labels on a Percentage Bar Chart

I have a percentage bar chart and a crosstab summarising the same data. The problem i have that the data labels on my bar chart are rounding values up as opposed to down like the crosstab does with percentage summaries.

For example in my crosstab one row's values are 75% , 12% and 12%.
In my bar chart the same data is diaplyed as 75%, 13% and 13%.

Does anyone have any ideas how i can format the data labels on my bar chart to reflect the data in the cross tab without showing decial precision?
0
DarthCook
Asked:
DarthCook
  • 2
  • 2
1 Solution
 
mlmccCommented:
Is the chart based on the cross tab or its own data?

Mike
0
 
DarthCookAuthor Commented:
The chart is based on its own data but does have corresponding data within the cross tab.

Thanks
0
 
mlmccCommented:
Are they summary values?

One way would be to use a formula that rounds down then use the formula for the chart.

mlmcc
0
 
DarthCookAuthor Commented:
Thanks, It works great.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now