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