Forum Discussion

elatreille's avatar
elatreille
Icon for Helper I rankHelper I
10 years ago

Compare yearly data from one date column

Hi guys,   I have a sheet with actually 5 columns 1. Office 2. Year of sale (ex:2014 in a text format) 3. Month of sale (ex: January in a text format) 4. Number of sale 5. Date (date format) ...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Hi Elatreille,

 

You can use clustered column chart to achieve thie requirement. Drag Month of sale to Axis, Year of sale to legend and Number of sale to Value.

 

Regards,

Charlie Liao