spreadsheet chart in percentages

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

  1. dpics macrumors newbie

    Joined:
    Mar 15, 2005
    #1
    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
     
  2. wordmunger macrumors 603

    wordmunger

    Joined:
    Sep 3, 2003
    Location:
    North Carolina
    #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.
     
  3. dpics thread starter macrumors newbie

    Joined:
    Mar 15, 2005
    #3
    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
     
  4. Le Big Mac macrumors 68020

    Le Big Mac

    Joined:
    Jan 7, 2003
    Location:
    Washington, DC
    #4
    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