Link to home
Start Free TrialLog in
Avatar of DarthCook
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?
Avatar of Mike McCracken
Mike McCracken

Is the chart based on the cross tab or its own data?

Mike
Avatar of DarthCook

ASKER

The chart is based on its own data but does have corresponding data within the cross tab.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks, It works great.