proportion

  1. R

    Formula help, please

    Hi All, Not sure how to explain this too well but here goes... I have a SS much like the below example, where i have a list of peoples incomes, in this example, 100 & 100. I then have a field with a total of expenses, in this example, 500. I then use a formula as shown below, which looks at...
  2. S

    proprtionality genuis required

    <tbody> on tue wed thu fri sat sumn total available F <colgroup><col width="64" style="width: 48pt;" span="8"><tbody> F 34 34 34 34 34 34 34 G 54 54 54 54...
  3. L

    Mini chart not working

    I have this problem with mini charts.... for some reason sometimes the charts are out of proportion internally. Try this example: Insert in 5 cells across these values 6 3 3 4 5 and the insert a bar minichart. The bars corresponding to the numbre 3 are out of proportion. I have an image...
  4. V

    Target based acheivement

    Hi all, I am facing some issue while setting up formula for target based incentive. Problem set has 3 classes: Below 80% achievement - payout is 0% at 92.5% achievement - payout is 100% Between 80% to 92.5% - payout is proportion (basically the gap between 80% and 92.5% represents 100%) At...
  5. 0

    Proportion based on percentile

    Hello all, I have two series of value I need to the proportion to figure out which is the value I should put based on my old valuations. I am going to explain better. Based on past series I have the below distribution: <colgroup><col style="width: 100px"><col width="100"><col...
  6. N

    100% Stacked Bar Chart, Heights Relative to Additional Values / Series

    Greetings, I'm trying to create a stacked bar chart, but with the length of the bar adjusted relative to a second series on the primary axis. I'm analyzing the occurance of key terms in the meetings of various departments, but I want the length of each department's bar proportional to the...
  7. N

    3D Chart Proportion

    I created a 3D column chart comparing data for 2007, 2008, and 2009. With 2009 data appearing towards the front and going back to 2007. Since the chart is 3D, the columns begin in a different position for each year, so that even though the data in the column towards the front is a larger value...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top