View Single Post
  #3  
Old September 15th, 2003, 10:22 PM
Tushar Mehta
external usenet poster
 
Posts: n/a
Default Need to Plot a Chart with out Numerical Values

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