Need to Plot a Chart with out Numerical Values

  • Thread starter Thread starter venkat
  • Start date Start date
V

venkat

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
 
venkat said:
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
Click to expand...

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
 
For High, Medium, Low, substitute 3,2,1. For the x-values, replace A-1
by 1, A-2 by 2, etc. Plot this new data.

Create two more dummy data sets. The first is points along the x-axis,
as in (1,0), (2,0), etc. The other is along the y-axis, as in (0,1),
(0,2), etc. Plot these two series.

Use Rob Bovey's XY Chartlabeler to label the 2 dummy axis as A-1, A-2,
etc. and Low, Medium, High. Hide the actual axis values (double-click
the axis, then, in the Patterns tab set the 'Tick mark labels' to
None).

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top