spreadsheet chart in percentages

[dpics]

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]

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.

 

[dpics]

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

 

[Le Big Mac]

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.