Column alignment on chart is wrong
Hi, I'm wondering if anyone can help with this as I'm really struggling. I added to this stack overflow post http://stackoverflow.com/questions/5997945/ssrs-2008-how-to-center-column-directly-above-month-tick-mark-in-column-chart as it described the same problem I'm having but I'm still yet to solve it. There's a couple images on the comments there which show the graph, the columns seem to start off to the left of the marker and then each column after that moves right until its off to the right of the marker. If I try and make the bars any wider which I also need to do, they then appear even further away from the mid marker. Apart from that everything appears correctly. Thanks for your time
May 15th, 2012 6:17am

Hi There I have tried to generate your issue in my test environment but I could not Can you please go to the x-axis properties and try to go major tick mark and label tab and try to do some setting in there I have put some screenshot for your help Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
Free Windows Admin Tool Kit Click here and download it now
May 15th, 2012 6:57am

Hi, thanks for the reply. Unfortunately that didn't really help, it makes it slightly less visible but I need to make the columns quite a lot wider, as soon as I start doing that it becomes a lot more noticeable, like this:
May 15th, 2012 7:06am

I've just changed the PixelPointWidth back to 0 for each series as I read this: "The default value of PointWidth is 0.8 (80% of the available space), so this is the value unless you have changed it. You can see this at design-time in the Chart's Properties window > Series collection > CustomAttributes tree. The default value of PixelPointWidth is 0, meaning the width is defined by pixels but by percent using the PointWidth custom attribute. " But this didn't change much
Free Windows Admin Tool Kit Click here and download it now
May 15th, 2012 7:22am

Here's the chart with 4 of the series taken out, so there's only two remaining: One displays left of the tickmark and the other to the right..
May 15th, 2012 8:59am

Hi JimmySavile, When we add a filed to the Series Groups area in a linear chart, for each instance of the category group, there will be corresponding space for each instance of the series group in sequence. For example, in the column chart below, I add Year filed to the category group and add Country filed to the series group. The chart looks like below: There will be corresponding space for each country above each Year label. Even if some countries are not displayed for a specific year, the space for the countries is still reserved. This is by design. In your chart, the series group has more than one instance, and that is why the bars not align as you expect. Besides, when you increase the PixelPointWidth, the space reserved for each bar will be increased. That way, the bars will be further way from the corresponding X-Axis labels. According to the screenshot you have posted, one possible workaround is to reorganize the data structure so that you can avoid using series group in the chart. Hope this helps. Regards, Mike Yin
Free Windows Admin Tool Kit Click here and download it now
May 17th, 2012 6:12am

Hi Mike, Thanks a lot for the reply, that makes a bit more sense now, still not entirely sure how to get around it though. As you can see from the top post I'm not using any series groups, just data fields. Each of the six column's data is calculated dynamically based on the underlying data set and the graph is nested in a bigger tablix so the datasource cannot provide the data in the exact format it needs which is why each series has its own calculated data. What would be a suitable workaround so that the space isn't allocate for each of the other series? Thanks for your time
May 17th, 2012 7:19am

If I remove the category value for each series it works a bit better, but then it won't show the category label or the data label value: Each series had a manual category set, 1,2,3 etc just so that it would space properly across the x axis. As well as not being able to have axis labels I can't seem to add any space between columns this way
Free Windows Admin Tool Kit Click here and download it now
May 17th, 2012 7:20am

If I remove the category value for each series it works a bit better, but then it won't show the category label or the data label value: Each series had a manual category set, 1,2,3 etc just so that it would space properly across the x axis
May 17th, 2012 7:23am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics