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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|