ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I get a graph to make my entries equal 100% in aggregate (https://www.excelbanter.com/excel-discussion-misc-queries/121994-how-do-i-get-graph-make-my-entries-equal-100%25-aggregate.html)

R. Lee White

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,

CLR

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,


Gord Dibben

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,




All times are GMT +1. The time now is 02:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com