View Single Post
  #2  
Old September 15th, 2003, 04:14 PM
dvt
external usenet poster
 
Posts: n/a
Default 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
Y-axes and Value chain represented by A-1, A-2..... in
X-axes 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 x-axis 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
x-axis. That is called a category type axis.

Dave
dvt at psu dot edu