DarthCook
asked on
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?
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?
ASKER
The chart is based on its own data but does have corresponding data within the cross tab.
Thanks
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, It works great.
Mike