Sign in to follow this  
pc06matt

showPlotBorder in MSAREA chart, need border in chart upper side only

Recommended Posts

Hi,

 

I have the following requirement. I need to create an MSArea chart, which looks like below:

 

post-67422-0-44214300-1466185327_thumb.png

 

Below is my MSAREA Chart code, enabling "showPlotBorder"

<%
ClipboardPage Pg = tools.findPage("D_SalesPerformanceVsQuota");
int qMaxLength = Pg.getInteger("pxResultCount");
%>
<chart decimals="0" numberprefix="$" plotgradientcolor="" showplotborder="0" bgcolor="FFFFFF" showborder="0" showalternatehgridcolor="0" showvalues="0" showcanvasborder="0" canvasborderalpha="0" legendshadow="0" legendborderalpha="0" labelDisplay="NONE" 
showLabels="0" minimiseWrappingInLegend="1" palettecolors="#A9B1BB,#A5EBC5" connectNullData ="1" drawAnchors="1" showPlotBorder="1" plotBorderThickness="2">

<categories>
<%
for(int i=1;i<=qMaxLength;i++) {
  ClipboardPage categoryPg = tools.findPage("D_SalesPerformanceVsQuota.pxResults("+i+")");
  String categoryName= categoryPg.getString("Category");
  String displayName= categoryPg.getString("DisplayText");
  if(displayName != null && !displayName.isEmpty()){
%>
	<category label="<%=displayName%>" showLabel="1" />
<%} else {
%>
	<category label="<%=categoryName%>" />
<%}}%>
</categories>

<dataset seriesname="Commit" plotBorderColor="#5a6572">
<%
for(int i=1;i<=qMaxLength;i++) {
  ClipboardPage seriesPg = tools.findPage("D_SalesPerformanceVsQuota.pxResults("+i+")");
  double dayAmt= seriesPg.getDouble("OppAmount1");
  double cumulativeSum= seriesPg.getDouble("CumulativeSum1");
  String oppName = seriesPg.getString("FirstName");
%>
	<set displayvalue="<%=oppName%>"  <% if(1==i || cumulativeSum!=0){%> value="<%=cumulativeSum%>" <%}%>/>
<%}%>
</dataset>

<dataset seriesname="Closed (Won)" plotBorderColor="#2ed177">
<%
for(int i=1;i<=qMaxLength;i++) {
  ClipboardPage seriesPg = tools.findPage("D_SalesPerformanceVsQuota.pxResults("+i+")");
  double dayAmt= seriesPg.getDouble("OppAmount");
  double cumulativeSum= seriesPg.getDouble("CumulativeSum");
  String oppName = seriesPg.getString("Name");
%>
	<set displayvalue="<%=oppName%>"  <% if(1==i || cumulativeSum!=0){%> value="<%=cumulativeSum%>" <%}%>/>
<%}%>
</dataset>

  <trendlines>
        <line  startValue="0" endValue="390000" color="#2A97DE" valueonright="1" displayvalue="Quota" showOnTop="1" thickness="2"/>
    </trendlines>
</chart>

I am getting chart something like this.

post-67422-0-24396800-1466185648_thumb.png

 

If you notice, in the second screen-shot, I am getting border color in red highlighted area also. We don't want that, we only want the border color to be in upper part of chart. 

Please suggest. Thanks!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this