Format chart output

I need to display a bargraph with the top 15 errors for a production line. I
have everything working the way I like it except for the times when ther are
not 15 errors then the bargraph automatically resizes. Then it looks
terrible. Especially when there is one one item returned - then you get 1
HUGE bar that goes acress the graph.
My question is - is there a way that I can always have 15 place holders for
the bargraph? so that no matter how many values I get returned the bargraphs
will always be the same size? (except for the number of bars that are
showing).
I tried setting the min and max in the x-axis and y-axis to 0 and 15 - but
if there are less than 15 it still resizes the bars.
Thanks in advance.Hi Mike,
is that your issue solved? i also facing this same issue, when there is one
data, it becomes a HUGE columns. Or let say the chart size is best to view
for 15 placeholders but the data is >15 placeholders, all the columns will
squeeze together.
i set the category axis min/max value, also no help on this issue.
any one can help? thanks.
"Mike" wrote:
> I need to display a bargraph with the top 15 errors for a production line. I
> have everything working the way I like it except for the times when ther are
> not 15 errors then the bargraph automatically resizes. Then it looks
> terrible. Especially when there is one one item returned - then you get 1
> HUGE bar that goes acress the graph.
> My question is - is there a way that I can always have 15 place holders for
> the bargraph? so that no matter how many values I get returned the bargraphs
> will always be the same size? (except for the number of bars that are
> showing).
> I tried setting the min and max in the x-axis and y-axis to 0 and 15 - but
> if there are less than 15 it still resizes the bars.
> Thanks in advance.