Plotting Excel Chart with two non numeric data

[Nishesh]

Hi from Wellington,

I have a single numeric data (Cheapest value) for which I want to plot two non-numeric values. In attached example, I have around 40 products (Products) for which I have identified the cheapest value and also identified which organization (cheapest vendor) will provide me that product.
Whats the best way to chart it as I could not do it by adding secondary axis. Also I could not download any other add'ins as suggested on the site due to restrictions with the place that I work with. I also could not edit each label with the formula with Custom labels (as suggested on the Chandoo site) as there are too many data points.

Please guide. I did post this in Excel user but I think this is the appropriate forum

Nishesh

 

[NARAYANK991]

Hi ,

Since this is a duplicate post, I am closing it.

Please refer to your earlier post for any replies.

Narayan