Hi,
Let me thank you in advance for any assistance you may provide.
I am new to making charts and am not having much luck using the MS Excel help. I need to make a chart displaying the following data:
I have 5 products that I invited people to put in order of importance to them. I now want to create a few charts to display the information. I have the excel spread sheet set up where Column A is numbered 1 thru 5, across the top (Row 1) I have listed the names of all respondents. Below each name I have listed the products in the order of their preference.
How can I now use this data? I need to know the rank (percentage) of product #1, #2 and so on, and display it in a chart. Is this possible? If so, how?
Bookmarks