Creating a grouped bar chart with multiple columns

user01706
user01706 Member
in Archive

Hi,

 

Can someone help with how to create a grouped bar chart with values from 2different columns.

Eg: dataset has 3 columns; date, apple sales, banana sales. How to show in a bar chart with date on x axis and apple sales & banana sales side by side in a grouped bar chart for each date?

 

Thanks in advance! 

Comments

  • jhl
    jhl Member

    Hi, you may want to check out this link to the knowledge base - there is a graph type called "grouped bar chart."

     

    You will have to put 

    -date into "category" 

    - apple sales into "value"

    - banana sales into "series"

     

    and the result will be something like the dummy data graph I have attached.

     

    HTH

     

This discussion has been closed.

Categories