Hello all.
I am trying to create a bar graph with the following parameters in Google Sheets. We are selling items from various categories (ie clothing, electronics, sporting goods, collectibles, etc). The categories are listed in my spreadsheet in column B. However, I only want the category to be counted IF there is a corresponding value in column F (column F is the column showing how much the item sold for, aka I only want the Category from column B to be counted in the chart if it has been sold). I have been able to create a graph showing a breakdown of the categories, but this is for all of the categories listed, not just for the ones that have sold. I'm sure there is a relatively simple solution, but I am just unsure how to go about this. Any help would be appreciated!
Bookmarks