nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Bar Chart with no values on X-Axis

Miss_Anonymus

Good Morning,
 
I have the following problem: I would like to create a bar chart with an underlying JDBC data source. when I have the following result:
 
 
Oranges Bananas Strawberries Cherries Apples
 
 5 10 14 0 7
 
 
 
And now I would like to create a bar chart, where these values are placed on the ground and on the left is a vertical scale (the y-axis) with measure values. The values above, witch I got from the DB should be displayed in the shape of a bar in the highness of its value. The bars should be displayed side by side, and the actual number should be displayed above the bar (e.g. The organges bar: there should be displayed 5 above it). Also null values should be visible (e.g. the cherries). look at the attached file.
 
How can I create this? I'm having problems with the eclipse plugin under the "select data" tab, there you can manage the value x- and y- series. But I have no actual x-values, because the bars should only be placed side by side.... What do I have to place where??
 
Thanks already for your help!

Find more posts tagged with

Comments

mwilliams

With that data, all you have to do is create a separate series for each, put a dummy value in the X-Axis field (this causes them to group together), and name your series appropriately. This is the output you get by doing that:

Miss_Anonymus

Thank you very much !!
 
But how can I display the null value of some bars (in this example, the cherries), too? I found out how to display the values above the bars but not, how to do it also with the "0" ?

mwilliams

I don't think there's a way to do this without scripting, but if you drop this script into your chart's script area, it should do it for you: <pre class="_prettyXprint _lang-auto _linenums:0">
function afterDataSetFilled( series, dataSet, icsc )
{
if(series.getSeriesIdentifier() != ""){
if(dataSet.getValues()[0] == 0){
dataSet.getValues()[0] = .000000001;
icsc.getExternalContext().getScriptable().setPersistentGlobalVariable(series.getSeriesIdentifier(),"not null");
}
}
}

function beforeDrawDataPointLabel( dph, label, icsc )
{
if(icsc.getExternalContext().getScriptable().getPersistentGlobalVariable(dph.getSeriesDisplayValue()) != null){
label.getCaption().setValue("0");
}
}
</pre>