Rounding Down Data Labels on a Percentage Bar Chart

Posted on 2009-05-07
Medium Priority
Last Modified: 2012-05-06
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?
Question by:DarthCook
  • 2
  • 2
LVL 101

Expert Comment

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


Author Comment

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

LVL 101

Accepted Solution

mlmcc earned 1000 total points
ID: 24335448
Are they summary values?

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


Author Closing Comment

ID: 31578946
Thanks, It works great.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
From store locators to asset tracking and route optimization, learn how leading companies are using Google Maps APIs throughout the customer journey to increase checkout conversions, boost user engagement, and optimize order fulfillment. Powered …
In the video, one can understand the process of resizing images in single or bulk. Kernel Bulk Image Resizer is an easy to use tool for resizing large number of images. One can add and resize multiple images with this tool in single go. The video sh…
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question