Grouped bar - Category as text and each bar (series) is a year
I need help making a grouped bar chart that shows each category as a text field (e.g. Aerospace, Automotive...) and each bar to be the value for the year.
For example one group would show Aerospace revenue for 2018, 2019, 2020 the next group would show Automotive revenue for 2018, 2019, 2020.
I am not having any luck putting a date field in the series location.
Added PNG to show you what I mean. This was done in Excel (hoping to replace Excel with DOMO).