Skip to main content
1 of 2
user avatar
user avatar

Is it possible to create a chart mapping two columns to each other?

I have a sheet that contains a list of books, with metadata about those books. Two columns that exist are the library within which the book is stored, and the condition of the book. I'd like to create a chart showing the number of books in each condition, per library.

The table looks something like this (excluding other non-relevant metadata)

Book     Library     Condition
1        Example1    New
2        Example2    VG
3        Example1    Fair
4        Example3    VG

I'd like a table that used the Library column as labels, and had a display for each possible condition in each library. A cluster bar graph would work, but an ideal would be something like a double pie chart (where the large slice is the breakdown by library, and that is the sliced by condition).

Tomas
  • 33
  • 1
  • 1
  • 3