Need to Plot a Chart with out Numerical Values
venkat wrote:
My problem is with ploting a graph in excel which has
abstract value i.e. it does not contain any numerical
value.
I need to plot a chart which has High, Medium & Low in
Yaxes and Value chain represented by A1, A2..... in
Xaxes and company name which will give me the graph
Pls Help
Thanks & Regards
Venkat
How do you rank your abstract values  alphabetically? importance? some
other criteria? And what happens if you have two occurences of "High" for
the same xaxis category? Once you have that figured out, you could write a
function in the spreadsheet to calculate the rank for each entry, then use
the standard chart types within Excel.
You can use many of the basic Excel chart types with abstract values in the
xaxis. That is called a category type axis.
Dave
dvt at psu dot edu
