ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Goal attaining formula (https://www.excelbanter.com/excel-discussion-misc-queries/108705-goal-attaining-formula.html)

Jess0628

Goal attaining formula
 
I am looking for a formula that will translate into a graph that will show
how much of our goal has been reached. Say I have a goal of raising
$5,000... I want to show $1,000, $2,000 and so on until I reach the goal...
Does anyone know of a way to pull this off? Thanks for your help.
Jessica

Dave F

Goal attaining formula
 
Why can't you just make a graph which charts your progress? You can refresh
the graph's data as you progress.

I'm not sure I understand how a formula would help you achieve this.
--
Brevity is the soul of wit.


"Jess0628" wrote:

I am looking for a formula that will translate into a graph that will show
how much of our goal has been reached. Say I have a goal of raising
$5,000... I want to show $1,000, $2,000 and so on until I reach the goal...
Does anyone know of a way to pull this off? Thanks for your help.
Jessica


Jess0628

Goal attaining formula
 
I am looking for something I can use on a website that would be "cuter" than
a bar graph... I guess formula is the wrong word choice...

"Dave F" wrote:

Why can't you just make a graph which charts your progress? You can refresh
the graph's data as you progress.

I'm not sure I understand how a formula would help you achieve this.
--
Brevity is the soul of wit.


"Jess0628" wrote:

I am looking for a formula that will translate into a graph that will show
how much of our goal has been reached. Say I have a goal of raising
$5,000... I want to show $1,000, $2,000 and so on until I reach the goal...
Does anyone know of a way to pull this off? Thanks for your help.
Jessica


Joe Mac

Goal attaining formula
 
There are many ways that the data can be captured, entered, and organized to
track a goal/target. I can send you a simple example of mock data and sample
graphs if you like
--
Thanks for your help -
Joe Mac


"Jess0628" wrote:

I am looking for a formula that will translate into a graph that will show
how much of our goal has been reached. Say I have a goal of raising
$5,000... I want to show $1,000, $2,000 and so on until I reach the goal...
Does anyone know of a way to pull this off? Thanks for your help.
Jessica


Florida User

Goal attaining formula
 
Check out these sites

www.emailoffice.com/excel/arrays-bobumlas.html

www.andypope.info/charts.htm



"Joe Mac" wrote:

There are many ways that the data can be captured, entered, and organized to
track a goal/target. I can send you a simple example of mock data and sample
graphs if you like
--
Thanks for your help -
Joe Mac


"Jess0628" wrote:

I am looking for a formula that will translate into a graph that will show
how much of our goal has been reached. Say I have a goal of raising
$5,000... I want to show $1,000, $2,000 and so on until I reach the goal...
Does anyone know of a way to pull this off? Thanks for your help.
Jessica



All times are GMT +1. The time now is 06:57 AM.

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