Excel charts and formulas

New Contributor

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. graph column.JPG 

1 Reply


Depends on your Excel version With 365 you may UNIQUE() the range, count result in range and build chart for the result