How to change Scale?

  • Thread starter Thread starter NooK
  • Start date Start date
N

NooK

I am creating a chart in Excel using two Columns as X and Y, everythin
is fine but the scale of the graph are according to those values an
what I need it the scale to be for example

X Axis = Log(X data)

Y Axis = Abs(Y Data)

Is it possible to change the scale of the graph like above but keepin
the graph with the original data?

Best Regards

Noo
 
For the Y data, you have to use a worksheet range (another column) that
transforms Y to ABS(Y).

Alternatively, you can use a defined name for your Y values. If your Y
values are in Sheet1!B2:B12, for example, press CTRL+F3, enter a name
like abs_y in the Name box, and in the Refers To box enter:

=ABS(Sheet1!$B$2:$B$12)

In step 2 of the chart wizard while creating a chart, or by choosing
Chart Data from the Chart menu on an existing chart, click on the Series
tab. Select the series in the list, and in the Y values box, enter
=Sheet1!abs_y

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
OK, what am I missing?

Why transform the Y values into ABS(Y) values? If they are negative,
they are negative, and it would be meaningless to plot them on a log
scale! For that matter, the same applies to the X values.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Well maybe the Log and ABS was a bad example.

What I am doing is that I am creating a linearized Weibull Chart (Don'
ask cause I don't even know what it is, just know what I am supposed t
do)

What I am doing is creating a Scattered Graph With this data

X Data = Ln(X)

Y Data = LN(LN(1/(1-Y)))

Now I have 4 Columns, the first 2 contain X and Y and the Third an
Fourth the exact formulas above using X and Y columns

I plot the graph according to the third and fourth columns since thi
is the only way one gets a Line on a Weibull chart but I want the scal
to show the respective values of X and Y (And Not Ln(X) and so on).

Thanks for the link to the PDF File but I had little success trying i
on myself, when I add another series I get a second coloured line o
the graph and after the formatting the graph doesn't look the sam
anymore.

Any help?

Best Regards

Noo
 
Tushar -

It's only meaningless because we don't know the context. I've had cases
where ABS(X) was a perfectly legitimate parameter. Besides, ABS and LOG
were separated in the description.

- Jon
 
NooK -

You can create a fake axis using a technique like this:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

Here are some specific implementations of the technique:

http://peltiertech.com/Excel/Charts/ProbabilityChart.html
http://peltiertech.com/Excel/Charts/RecipAxisChart.html

Your last paragraph makes me suspect you are not using an XY Scatter
chart. If you're doing any kind of data analysis (i.e., Weibull), you
can't survive with Line charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top