A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Need to Plot a Chart with out Numerical Values



 
 
Thread Tools Display Modes
  #1  
Old September 15th, 2003, 09:46 AM
venkat
external usenet poster
 
Posts: n/a
Default Need to Plot a Chart with out Numerical Values

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
Ads
  #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


  #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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.