spreadsheet chart in percentages

dpics

macrumors newbie
Original poster
Mar 15, 2005
5
0
I'm assuming that this is a really basic function that I'm overlooking.
For example...I have numbers of monthly bills, I enter the cash
amount for each month, say I end up with 12 rows 12 colums (one set vendors one set months)
the highest figures for some may be hundereds, for others thousands.
I want each and all of these vendors figures for to be shown on chart
where one axis is time(months) and the other is 0 -> 100%

thanks in advance

PS

I have Appleworks and Office 2001 in OS 9.2
 

wordmunger

macrumors 603
Sep 3, 2003
5,124
2
North Carolina
dpics said:
I'm assuming that this is a really basic function that I'm overlooking.
For example...I have numbers of monthly bills, I enter the cash
amount for each month, say I end up with 12 rows 12 colums (one set vendors one set months)
the highest figures for some may be hundereds, for others thousands.
I want each and all of these vendors figures for to be shown on chart
where one axis is time(months) and the other is 0 -> 100%

thanks in advance

PS

I have Appleworks and Office 2001 in OS 9.2

I think you need to set up another area in your spreadsheet that converts your dollar figures to percentages. Total up each month in a column, then create a whole new set of columns that divides the relevant column by the total and expresses it as a percent. Then graph the percentages.
 
Comment

dpics

macrumors newbie
Original poster
Mar 15, 2005
5
0
Thanks

I guess I was assuming that with the variety of preinstalled functions
that I was missing it, seems it would be comon need to see relative changes
over time
 
Comment

Le Big Mac

macrumors 68030
Jan 7, 2003
2,592
168
Washington, DC
dpics said:
Thanks

I guess I was assuming that with the variety of preinstalled functions
that I was missing it, seems it would be comon need to see relative changes
over time
you shouldn't need to do much work. just set up the formula once and fill down or fill across to set up the new table.
 
Comment

Similar threads

Replies
0
Views
376
  • Plughugger
4
Replies
4
Views
1K
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.