+ Reply to Thread
Results 1 to 9 of 9

What is the excel normalization calculation to put different scaled values on same graph?

Hybrid View

  1. 12-21-2021, 10:21 PM #1
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,789

    Re: What is the excel normalization calculation to put different scaled values on same gra

    It does not adjust them so they can be visually compared. It just sets the scales separately based on the range of the data in each series. It is the same you would get if you had each data series in a separate graph.

    two axes.JPG
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  2. 12-22-2021, 04:46 AM #2
    c43
    c43 is offline
    Registered User
    Join Date
    06-14-2020
    Location
    Monaco
    MS-Off Ver
    2019
    Posts
    22

    Re: What is the excel normalization calculation to put different scaled values on same gra

    Quote Originally Posted by 6StringJazzer View Post
    It just sets the scales separately based on the range of the data in each series.
    Attachment 760311
    Can you point me where I can read in detail about how it sets the scales and defines the ranges, please. I am interested in the proccess behind it, whatever it is that it does. Like the formula of how it scales and defines ranges etc. Thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Dynamically scaled Graph Axis - Not working
    By dante051967 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2019, 05:01 PM
  2. [SOLVED] Data normalization in Excel - how to with certain example
    By jaryszek in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-14-2018, 05:14 AM
  3. New Column with Time Scaled Values
    By naeemdotcom in forum Excel General
    Replies: 6
    Last Post: 01-21-2011, 07:50 AM
  4. Normalization
    By chaitanyak in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-07-2010, 04:27 PM
  5. Reading values from a logarithmic scaled x-axis
    By lightning87 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-27-2007, 04:03 PM
  6. Scaled Prints and shapes in Excel
    By Claude in forum Excel General
    Replies: 0
    Last Post: 06-05-2006, 04:25 PM
  7. Normalization
    By Jar in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-17-2005, 12:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1