I'm trying to create a grouped bar chart. I have the following sample data:
LOAD * INLINE [
Country, Sales, Costs
USA, 1000, 800
UK, 800, 700
Germany, 900, 1000
Japan, 600, 400
I have set the style for the chart to be grouped, but it always shows stacked. Screenshot of actual table and settings
in the properties.
What am I missing? I am running 11.2 r5 on Windows 7. My forehead style is flat.
Solved! Go to Solution.
like Massimo said, you have sales and costs in your dimensions along with Country. removing the sales and costs from dimensions and leaving country alone as a dimension should take care of your issue.
Currentely you are using Sales in Dimension that why it showing stack chart.
use only coutry in dimension
move your sales to Expression
in dimension Country
and sales and Cost in Expression
hope this helps
Removing the costs and sales from the dimensions tab allowed me to change the appearance in the style tab to grouped, and the preview on the style tab then showed up as grouped, but that had no effect on the chart when the change was applied. However, creating a second chart Country as the only dimension created a grouped bar chart. Also, closing the document and reopening it caused the first chart to appear as grouped. I tried reloading the data before I closed and reopened the document, but that didn’t have any effect.
This seems like a bug to me.
Thanks to all for your very prompt help. The forum is awesome. Far superior to any other BI forum I have seen.
I tried the same thing,
- downloaded your doc
- removed two dimensions
and I still got the grouped bar chart without any problem
Reload, close, open, etc......always grouped
I have 11.20 SR5, perhaps a different version........?
I am using the Personal Edition, but I would not think that would cause the issue.
As of now, switching between grouped and stacked is now working properly. Adding the unneeded dimensions causes the
chart to switch to stacked, but removing them allows me to set it back to grouped. I can’t recreate my initial problem.