magnitude

  1. JenniferMurphy

    Variable formatting of time values

    Is there a function, add-in, or easy way to format time values so that the units displayed vary with the magnitude of the value? What I mean is that the function will convert the value to the units that will be >1 but less that "1" of the next higher units. If the value is less than one...
  2. DRSteele

    PQ: Max of absolute values in across columns

    Can someone please help me in Power Query? I would like a custom column to report the maximum magnitude of values per record, in other words I would like the max absolute values. The column names are on row 30. It seems easy in Excel, but I can't figure out the syntax in PQ. <colgroup><col...
  3. S

    Creating A Chart Showing Magnitude (2 X-Axis)

    Hi, I am trying to create a chart that shows the magnitude (first X axis) of a weighted average (Y axis) per Unit (second X axis). It needs to visually show the weighted average over time. Can you individually stretch each bar on a bar graph to show individual magnitudes? Thanks for all your...

Watch MrExcel Video

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