proportion

  1. L

    Power BI -Proportion of overall criteria * Average

    Good Afternoon I need help to work out how to show the proportion of days taken per category. I have posted how this looks in Excel however I am struggling to create a Measure in Power BI to replicate it. My data is in one large table, called Sheet 1! The example below: first 2 columns are...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top