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
In article , venkat_
says...
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