More Charting Tips

Too many questions on the love of my life, BIP charts. Oh the joy of finding out how to add a trendline or a fixed horizontal line, the list goes on. Its quite easy really but that's because I have an internal chart rendering tool that generates the XML I need to do cool stuff in charts. Some times I have to resort to scouring the chart DTD but the tool lets me test the feature I want. Sadly, the tool is not owned by BIP so we do not have the authority to make it public but I so wish it were. It would help you to help yourselves sooo much.

Two things to cover today ...

X Axis Labels


I've a Bar chart where X-axis labels are coming as horizontally-alligned and one value above, next value in a level on.
Is it possible change the alignment to -45 degree as it is available in excel chart? x-axis data label points will be displayed in uniform way then.


45 degrees is not possible at the moment. you can get them to show at 90 or 270 degrees thou


<O1TickLabel textRotation="TR_HORIZ_ROTATE_90" automaticRotation="AR_NO_ROTATE"/>


you can influence other properties too


<O1TickLabel textRotation="TR_HORIZ_ROTATE_90" automaticRotation="AR_NO_ROTATE">

There was a followup kindly answered by Vetsrini

Fixed Axis Scale

Is it possible to define a fixed scale for x-axis? I see by default Bipublisher decides scale based on the value coming from dataset. I want to set scale always from 0 to 500 with label showing at interval of 10. 
<X1Axis axisMinAutoScaled="false" axisMinValue="0" axisMaxAutoScaled="false" 
axisMaxValue="500" majorTickStepAutomatic="false" majorTickStep="10"/>

 and then,
Static Chart Line

How do I show a static line on my chart?

 Vetsrini and I seemed to be in a race to answer charting questions yesterday :0)

Inside the Graph tag use: 

<ReferenceLine index="0" visible="true" lineWidth="2" text="My Ref Line" value="550.0" displayedInLegend="true" lineColor="#3366ff"/>

and finally

Trend Lines

 Does BIP have the ability to create trend/regression lines?

 Yep, it does, manual job like the others above but possible.
Under the Graph tag 

<SeriesItems defaultFitlineType="FT_LINEAR"/>

 Valid vaues for fitlinetype are FT_LINEAR|FT_LOGARITHMIC|FT_EXPONENTIAL

if you want multiple lines fitted to data points

<Series id="0" fitlineType="FT_LOGARITHMIC"/>
<Series id="1" fitlineType="FT_EXPONENTIAL"/>


I'll blog em as they come in and we manage to answer them. Happier charting!


Hi Tim, Sorry about the race ;), didn't think, with whom am racing ~Vetri

Posted by Vetri on August 20, 2009 at 05:21 AM MDT #

Tried the Regression suggestion, and the chart does not render at all. Just a blank page. Am I doing something wrong? Posted my syntax here (not working if i post it here) thanks for helping

Posted by PC on August 24, 2009 at 01:22 AM MDT #

I have a bar - horizontal - percent chart with the percentage data labels on the bar. Any ideas how I can limit the format to be ##.##%. Right now it shows some numbers as ##.###% and others as ##.##%

Posted by Anna on June 13, 2013 at 02:12 PM MDT #

Hello Tim, How you can get and edit the xml code of the report?

Thanks for your response.


Posted by Cristian on November 15, 2013 at 08:23 AM MST #

If you mean for an online template, you can not, officially. You can go in and find the xpt file and edit it but you are not going to be supported.

If you are talking about an RTF template with a chart. Open the chart dialog and open the other tab at the top of the dialog to see the chart XML text.



Posted by Tim on November 15, 2013 at 04:14 PM MST #


Thanks for your response. After tried the two methods mentioned by you above:

The examples given works perfectly in a RTF template, however I supouse that if I want to do this kind of customizations to an on line template, I mean modify the xpt file, this must be done in a diferente way right?

I think that because I tried to get the same results editing the xml code in the xpt file, but I didn't get the same results. In fact, it didn't works. First, the sintax of the xml code in the xpt file is very different to the sintax of xml code obtained on the RTF template.

My final question is: If I want to do a complex template in BI Publisher, this must be done across RTF templates? or there is a way to do this type of customizations with other types of templates?

Very grateful for your attention.


Posted by Daniel on November 18, 2013 at 03:09 PM MST #

Hi Daniel
I think the xpt format stores the chart code differently to the RTF templates.

The online templates (xpt) get you only so far. The RTF templates allow you to much much more ie anything you want.


Posted by Tim on November 19, 2013 at 11:19 AM MST #

Hi sir,

scaling for x-axis is not working.Is there any way to scale x-axis because it accept only text value which is used label inside the graph.
Please sir, let me know about the solution

Thank you

Posted by Durgesh Shukla on September 04, 2014 at 12:51 AM MDT #

Good day

I produced with great difficulty a vertical percentage chart with more than one bar. My problem no is the labels. It either appears all at the top, all on top of each other, or in the middle all on top of each other. How does one correct that ?

Posted by chris on October 22, 2014 at 02:53 AM MDT #

Its tough to help in a blog comment. Have you logged an SR for the problem to get some help from support?



Posted by Tim on October 22, 2014 at 12:18 PM MDT #

Post a Comment:
  • HTML Syntax: NOT allowed

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!


« June 2016