Mirror a graph

jsimpple · July 4th, 2002, 8:23 am

Hi,I'd like to know if there is a way to mirror the graph on the x-axis without adding a minus sign to the original data.i.e if I've a +VaR data, could I plot a -VaR data on the chart without adding another colum to my worksheetThanks!!!

Yuka · July 4th, 2002, 9:22 am

not sure if this represents an advantage over adding another column, but you could try defining a name that takes the inverse of the original data and using this as a chart input..let me know if you don't understand what I mean

Anthony · July 4th, 2002, 12:40 pm

Try this xls, it uses like Yuka said a named range, but allows you to type the formula into a cell. It uses the evaluate() function.

Yuka · July 4th, 2002, 3:49 pm

The evaluate() function - I've never having heard of this one before, it's not documented in the help file. But what a great function! Some digging around unearthed this example of its usage http://www.geocities.com/SiliconValley/ ... lotfcn.zip - good call Anthony.

Anthony · July 4th, 2002, 5:59 pm

I only discovered it alittle while back and shared it with the forum in a post called something like 'graphing a chart'. I think the evaluate() function is used internally in Excel for maybe the linest() function or table() menu function. Its on my 'to-do' list to get it to run a flexible scenario analysis on my exotic book without taking too much memory up.

jsimpple · July 5th, 2002, 5:03 am

Hi Anthony n Yuka,Thanks for your helpful tips. I manage to get the graph I need w/o creating any extra column:-)However, I'm a bit puzzledEvaluate formula uses e.g EVALUATE(Sheet1!$C$3&"+X*0")(where Sheet1!$C$3 contains the formula) I don't quite understand the usage of : &"+X*0"I manage to get the same answer using EVALUATE(Sheet1!$C$3&"+0")How come when we name Y = Sheet1!$C$3and name Z = EVALUATE(Y)Excel recognize that Y is a formula, BUT we can't use EVALUATE(Sheet1!$C$3) directly?Just to clear my curiosity, please forgive my shallow knowledge on Excel functionThanks again!!!And great picture Yuka!!

Anthony · July 5th, 2002, 5:36 am

I don't quite understand the usage of : &"+X*0" >>That forces the calculation in Excel to make it an array.please forgive my shallow knowledge on Excel function >>Its undocumented so I shouldn't worry.

Yuka · July 5th, 2002, 6:33 am

How come when we name Y = Sheet1!$C$3and name Z = EVALUATE(Y)Excel recognize that Y is a formula, BUT we can't use EVALUATE(Sheet1!$C$3) directly? >>I had no problems entering the formula as x*-1 and the setting Z=EVALUATE(Sheet1!$C$3) - i got the same graph as before...please forgive my shallow knowledge on Excel function >>I'm fairly new to the names in charts thing too - I think they're great though - I wish I'd known about them a long time ago.And great picture Yuka!! >>Thought the avatar could do with brightening up!

jsimpple · July 5th, 2002, 8:45 am

Yeah that solves my problem.I often read with delight the topic discuss in Wilmott forumsIt's really a good learning place for amateur like me ... DO keep the discussion alive!!!Cheers