Details about this thread
  • State Not Answered
  • +1 person also asked this people also asked this
  • Replies 4 replies
  • Subscribers 313 subscribers
  • Views 3076 views
  • Users 0 members are here

clustered bar chart instead of stacked

Joe Carter

Hi 

Does anyone know how I can get graphs to mimic excel in this one the Quarters are group

Excel Example

SugarCRM Example

In SugarCRM I group by Quarter/Year and get this if I do Year/Quarter I get a stacked bar chart.  

Is there any way with or without a plugin I can recreate the top image??

Any help much appreciated.

Parents
  • 0

    Hi Joe,

    To display the grouped bar chart does require some code changes unfortunately.

    This is a normal stacked bar chart:

    Normal stacked bar chart

    Same chart with "stack" set to false and "showControls" set to true:

    Grouped bar chart

    Those options aren't currently displayed in the Saved Reports Chart dashlet currently but could be implemented by code in a custom package.

    Please let me know if the details would be of interest to you (would require administrative privileges).

    Sincerely,

    Henry Rogers

Reply
  • 0

    Hi Joe,

    To display the grouped bar chart does require some code changes unfortunately.

    This is a normal stacked bar chart:

    Normal stacked bar chart

    Same chart with "stack" set to false and "showControls" set to true:

    Grouped bar chart

    Those options aren't currently displayed in the Saved Reports Chart dashlet currently but could be implemented by code in a custom package.

    Please let me know if the details would be of interest to you (would require administrative privileges).

    Sincerely,

    Henry Rogers

Children
  • 0 in reply to Henry Rogers

    Hi Henry

    Thanks for the reply I have managed to get dashlet working but can't get the grouped NOT stacked to show on the Main reports,  do you know a way to do this?

    Regards

    Joe