Creating a grouped bar chart with multiple columns

user01706

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! 

jhl

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