I want to be able to create a speedometer where $ will be my values in Millions.

It will need to have the following characteristics:

• Anything less than $M will be red, anything more than $1M will be green.
• breakeven will be zero.

I want to be able to input a number in millions like $4.5M as 4,500 and be able to dial that in the graph. at the same time I want to be able to input a negative number like -$10.0M like -10,000 and show that movement in the graph.

Help please!

Hi,

According to your description, my understanding is that you want to create a "speedometer" like an automatic graph. When you enter the value, the "speedometer' will automatically changed the color that based on the value, am I right? If yes, your request need some VBA code, I recommend you post the question to MSND forum:

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

If I misunderstand something, please feel free let me know.

George Zhao
TechNet Community Support