One way you can achieve this is, you can load the Table 1 as mapping table and add 'Total' to the Table 2 using applymap() function. Where there is no 'Total' for any 'Fruit category' there you can assign 0 as default 'Total' or Null().
Then you can plot a chart with 'Fruits Category' as dimension and 'Total' as measure. Then you need to suppress zero values or Null values from the fields. If you use 0 as default value, then on the chart properties--> add ons--> handle data -->Uncheck include zero values. If use Null( ) as default in applymap() then on the Dimension field -->uncheck 'Include null values.
Note: when loading the mapping table (table 1) make sure to change the name of 'Fruits' field to 'Fruits Category' so that the apply map works.