Jun 15 2021 12:34 PM
Good morning!
I am looking to make some bar graphs and pie charts from mountain lion prey species data. I will continually get data and would like to format the graphs in a way that are "live" and automatically update as additional data is added to the column. I have attached a screenshot of the column of interest. Ideally, the x axis of the graph would list different prey species from the column and the y axis would just be a count for the bars on the x axis.
Jun 15 2021 12:45 PM
Depends on your Excel version With 365 you may UNIQUE() the range, count result in range and build chart for the result