Hello,

Okay.. so I'm not sure if this is even possible, but I need to create a chart based on multiple values within a cell. I created a VB code that will enter multiple criteria into one cell, but now I need to be able to create a graph based on each independent value. For instance, if "apple" is selected and is included in a cell with "orange, grape, grapefruit" I need the chart to reflect the dollar amount for each independent fruit.

Thanks so much!

Create a chart based on multiple values in one cell.xlsx