Stacked Bar Chart Question

[Former Member]

Hi, I am creating a stacked bar chart, and I am encountering 3 issues I hope you can help me with:

1) The chart has positive and negative values. I have zero based centerline checked, but I do not see 0 on the Y axis.

2) The applet width is 900 pixels. The chart can have a variable number of bars. When it has a small number of bars, they fill the entire chart. Is there a way to set the width to a fixed amount?

3) Is there a way to set a logical interval amount? Currently the numbering is not intuitive.

Thanks

p.s. We are using 11.5.3

Edited by: Richard Keegan on Jun 13, 2008 5:18 PM

[Former Member]

1. The negative values might be throwing off the 0 based center line. Maybe that only works for positive values?

2. Try playing with the 3 Bar Spacing attributes on the first tab of the TemplateEditor.

3. You can if you fix the y axis to a fixed number and then play with the y-axis tick mark settings.

[agentry_src]

Depending upon your query structure, you can force a zero based centerline by setting the Y-axis ranges dynamically. I am not working in 11.5.3 currently, but ran into a problem with line charts in 12.0.2. The zero centerline flag did not work, so I dynamically generated the ranges and linked them in.

You can probably do the same with a little extra BLS coding.

Mike