Samuel Posted September 2, 2009 Report Share Posted September 2, 2009 Hi, I am creating a bar chart, which displays 10 different sector information. I have just 96% over all sum of all the 10 sector values. on that case, the point values are not matching to the value in database. if i have 100% sum, the chart have point values matching to my database values. on debugging i found that chart automatically rounded up to a 100%. How can i make the chart. Show the actual values in the database? I dont want the over all sum to be 100%. i can make a change in procedure to get Missing value in seperate record. can i make that (point label) Missing and (point value) 4% invisible? Some one please provide me a solution. Urgent please Thanks in advance ChartTest.zip Quote Link to comment Share on other sites More sharing options...
CarlosAC Posted October 5, 2009 Report Share Posted October 5, 2009 Hi Samuel<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> I would like to help you, but at this moment is kind of difficult to understand your issue. Are you using a stacked bar chart? Can you please attach a screenshot of your issue? -- Pipon Quote Link to comment Share on other sites More sharing options...
Samuel Posted October 6, 2009 Author Report Share Posted October 6, 2009 Hi, I got the answer. The following line is the reason for my issue.. ChartStrategySectorAnalysis.AllSeries.PointLabels.Format = " %p%%";In the display label, i am trying to include a space between number and % symbol. On this time it recalculates to 100 percentage. Example, there are 4 values in database... 25, 31, 15, 25. If the line mentioned above is not included in the code. The chart displays with the same data in the database. On including the line, the chart have values 26,32,26,26. (Total rounds to 100, which is wrong in my case) Hope i explained it clear. Thanks Quote Link to comment Share on other sites More sharing options...
CarlosAC Posted October 6, 2009 Report Share Posted October 6, 2009 Hi Samuel. Please use following code: ChartStrategySectorAnalysis.AllSeries.PointLabels.Format = "%v %%" -- Pipon Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.