spreadsheet chart in percentages

Discussion in 'Mac Apps and Mac App Store' started by dpics, Mar 15, 2005.

  1. dpics macrumors newbie

    Mar 15, 2005
    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


    I have Appleworks and Office 2001 in OS 9.2
  2. wordmunger macrumors 603


    Sep 3, 2003
    North Carolina

    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.
  3. dpics thread starter macrumors newbie

    Mar 15, 2005

    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
  4. Le Big Mac macrumors 68030

    Le Big Mac

    Jan 7, 2003
    Washington, DC
    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.

Share This Page