Urgent graphing question
Posted by sinz on October 05, 2001 10:01 AM
I've got to make a graph with the names of certain devices along the X-Axis. Each device has a price (approximately $700-$1000) and a rating (1.0 - 10.0). My problem is that I can't figure out how to make the Y-axis divide the Price valuse by 100 so they show up as 7.0 - 10.0 in order to have the ratings and prices show up in the same area. Please e-mail me or respond ASAP.
Posted by Eric on October 05, 2001 10:29 AM
Plot the prices on a second Y axis or convert the numbers on the excel spreadsheet prior to graphing
To use the second Y axis solution, go ahead and make the graph. Double click on the series representing $ and select the "axis" tab. click the "secondary axis" radio button, is that what you wanted?
Posted by sinz on October 05, 2001 10:36 AM
Re: Plot the prices on a second Y axis or convert the numbers on the excel spreadsheet prior to graphing
This is the actual goal of the project I'm doing. I can't figure out how to do this one step. I think both values need to be on the same axis, just that the prices need to be represented in hundereds instead of thousands, i.e. (10.0 = 1000)
use the Excel Chart Wizard button to make a line graph which should have the machines on its X-axis (across the bottom), and it should plot one line for the performance/price ratio, and another for the price. (Show price in multiples of 100 or 1000, so both lines fall into the same range.)
Posted by Eric on October 05, 2001 7:58 PM
say prices are in A2 to A10, could you put =a2/100 in B2 and copy down to B10, then plot the B column rather than A?(NT)
