Hi
Apologies if this question is in wrong forum as my requirement is both a function and a charting question. I have a number of rows on a worksheet and 3 columns (well 3 for the purpose of this question anyway). Column A is a location code (always single value and unique) , Column B is the customers of that location and Column C the suppliers. Column B and C both contain variable values including blank, single value or multiple values seperated by a comma.
I have attached the data, and my end requirement is produce bar charts showing the number of locations with 1-5 Customers, 6-10 Customers, 11-15 Customers, 16 or more Customers and the same for suppliers ie 2 bar charts.
Can you advise how I produce this ie how to do I know how many values are in a cell if they are text seperated by comma and then I can probably go on to generate the chart myself, but if my requirement is clear I would really appreciate help in getting from A-Z
Thanks so much in advance
Darren
Bookmarks