Revenue Thermometers

[cpalme]

I am looking for a way to represent forcasted revenue, accrued revenue and
unsold
in a Thermometer. Ideally I would like to enter the numbers in a
spreadsheet and
the Thermometer would be updated. I see that Visio has some good
thermometer graphics but can't figure out how to link them to a spreadsheet.
Anyone have any ideas?

 

[JoAnn Paules]

You can make a thermometer with Excel. I have an Excel Charts for Dummies
books and they tell you how to create it. (The book is at work and I'm not.)

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

 

[JoAnn Paules]

http://www.mrexcel.com/tip095.shtml

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

You can make a thermometer with Excel. I have an Excel Charts for Dummies
books and they tell you how to create it. (The book is at work and I'm
not.)

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

I am looking for a way to represent forcasted revenue, accrued revenue and
unsold
in a Thermometer. Ideally I would like to enter the numbers in a
spreadsheet and
the Thermometer would be updated. I see that Visio has some good
thermometer graphics but can't figure out how to link them to a
spreadsheet.
Anyone have any ideas?

 

[cpalme]

THANK YOU!!!!! That is perfect! Exactly what I needed. I can't tell
you the number of hours you have saved me.

Thank you,
CPalme

http://www.mrexcel.com/tip095.shtml

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

You can make a thermometer with Excel. I have an Excel Charts for Dummies
books and they tell you how to create it. (The book is at work and I'm
not.)

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

I am looking for a way to represent forcasted revenue, accrued revenue and
unsold
in a Thermometer. Ideally I would like to enter the numbers in a
spreadsheet and
the Thermometer would be updated. I see that Visio has some good
thermometer graphics but can't figure out how to link them to a
spreadsheet.
Anyone have any ideas?

 

[JoAnn Paules]

Don't thank me - thank Mr Excel, who happens to be a fellow MVP. (He's
really good though, isn't he?) ;-)

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

THANK YOU!!!!! That is perfect! Exactly what I needed. I can't tell
you the number of hours you have saved me.

Thank you,
CPalme

http://www.mrexcel.com/tip095.shtml

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

You can make a thermometer with Excel. I have an Excel Charts for
Dummies
books and they tell you how to create it. (The book is at work and I'm
not.)

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375


I am looking for a way to represent forcasted revenue, accrued revenue
and
unsold
in a Thermometer. Ideally I would like to enter the numbers in a
spreadsheet and
the Thermometer would be updated. I see that Visio has some good
thermometer graphics but can't figure out how to link them to a
spreadsheet.
Anyone have any ideas?