Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get a graph to make my entries equal 100% in aggregate
I am trying to crate a chart/graph that will use one bar to make my entries
equal a 100%. Like a fund rasing thermometer basically. I have a goa of $200k, and have already collected $47K. I would like to illustrate that in a graph, but do not know how. Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get a graph to make my entries equal 100% in aggregate
Have you considered a PIE chart......they pretty effectively express the
comparison of values.......... Vaya con Dios, Chuck, CABGx3 "R. Lee White" wrote: I am trying to crate a chart/graph that will use one bar to make my entries equal a 100%. Like a fund rasing thermometer basically. I have a goa of $200k, and have already collected $47K. I would like to illustrate that in a graph, but do not know how. Thanks, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get a graph to make my entries equal 100% in aggregate
Lee
Check out Andy Pope's site for how-to. http://www.andypope.info/charts/thermometer.htm Gord Dibben MS Excel MVP On Fri, 8 Dec 2006 11:58:01 -0800, R. Lee White wrote: I am trying to crate a chart/graph that will use one bar to make my entries equal a 100%. Like a fund rasing thermometer basically. I have a goa of $200k, and have already collected $47K. I would like to illustrate that in a graph, but do not know how. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you make an graph containing an algerbrica formula? | Excel Worksheet Functions | |||
Can I make a graph using several tabs in an excel spreadsheet | Excel Worksheet Functions | |||
How to make cumulative totals appear on a graph | Excel Discussion (Misc queries) | |||
How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions |