{"id":5698,"date":"2019-02-15T11:00:48","date_gmt":"2019-02-15T05:30:48","guid":{"rendered":"https:\/\/gtm360.com\/blog\/?p=5698"},"modified":"2022-02-24T16:43:16","modified_gmt":"2022-02-24T11:13:16","slug":"why-do-people-lie-with-charts","status":"publish","type":"post","link":"https:\/\/gtm360.com\/blog\/2019\/02\/15\/why-do-people-lie-with-charts\/","title":{"rendered":"Why Do People Lie With Charts?"},"content":{"rendered":"

In\u00a0Three Ways To Lie With Charts<\/strong><\/a>, we saw the following tactics:<\/p>\n

    \n
  1. Slippery Slope Slide<\/li>\n
  2. Floating Origin Fraud<\/li>\n
  3. Dual Axis Deception<\/li>\n<\/ol>\n

    The most common reason for people to lie with charts is that they are shilling some product, service or ideology and run into facts that derail their pitch, so they need to lie to continue with their pursuit.<\/p>\n

    But, after reading my previous post, some kind-hearted souls among you argued that lying is not the only motivation for people to create \/ spread misleading charts.<\/p>\n

    I took that objection seriously and did a deep dive of the other likely reasons.<\/p>\n

    This blog post is the result.<\/p>\n

    \"\"<\/a>Slippery Slope Slide<\/strong><\/p>\n

    Maybe the label of the stock price (256.3) on the last day was a typo. But, with novel ways of lying with charts coming up every day, what do I know?<\/p>\n

    Floating Origin Fraud<\/strong><\/p>\n

    This could be a problem caused by default settings in Excel.<\/p>\n

    \"\"<\/a>Back in the day, the Y-axis of a line chart on Excel would begin at zero by default. Whereas in recent versions, I’m noticing that the Y-axis begins, by default, near the smallest value of the dataset on that axis. While the change in default setting has resulted in a chart that makes better use of white space, the appearance of the chart drastically comprises the integrity of the data. For that reason, it’s wrong.<\/p>\n

    Let me illustrate this problem by using this Excel spreadsheet<\/strong><\/a>, in which the data\u00a0on the Y-axis ranges from 81 to 86.<\/p>\n\n\n<\/colgroup>\n\n\n\n\n\n\n
    2011<\/td>\n86<\/td>\n<\/tr>\n
    2012<\/td>\n84<\/td>\n<\/tr>\n
    2013<\/td>\n83<\/td>\n<\/tr>\n
    2014<\/td>\n82<\/td>\n<\/tr>\n
    2015<\/td>\n81<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    I used the following default chart settings in the ‘Default Chart’ tab:\u00a0Select both columns; Insert > Scatter Chart > 2nd Option > Default chart settings.<\/p>\n

    As you can see, the Y-axis on this chart begins at 80, which is just one unit lower than 81, the lowest value on the Y-axis data series; and the chart that results is misleading (Exhibit 1).<\/p>\n

    \"\"<\/a>
    EXHIBIT 1: Default Excel Settings<\/figcaption><\/figure>\n

    To fix this,\u00a0I changed the settings in ‘Modified Chart’ tab as follows:\u00a0Select both columns; Insert > Scatter Chart > 2nd Option > Change chart settings > Layout > Primary Vertical Axis > Primary Vertical Axis More Options > Change Minimum Value from Auto to 0; Change Maximum Value from Auto to 100.<\/p>\n

    Now, the Y-axis begins at 0, as it should, and the chart conveys the correct picture (Exhibit 2).<\/p>\n

    \"\"<\/a>
    EXHIBIT 2: Modified Excel Settings<\/figcaption><\/figure>\n

    Dual Axis Deception<\/strong><\/p>\n

    \"\"<\/a>I thought this chart was an outright attempt to mislead readers. But, then I found that Excel was the culprit again.<\/p>\n

    I don’t know how to change the default settings to prevent this dual-axis chart from being misleading and couldn’t be bothered to learn.<\/p>\n

    Since I can’t “beat ’em”, I decided to “join ’em”.<\/p>\n

    Here’s a misleading contribution of my own that stokes my hypothesis that Fintechs Shouldn\u2019t Stop Drinking The Disruption Kool-Aid<\/strong><\/a> despite their – ahem – humble accomplishments on disruption in actual practice (Exhibit 3).<\/p>\n

    \"\"<\/a>
    EXHIBIT 3<\/figcaption><\/figure>\n

    Ha ha:)<\/p>\n

    \n

    Typo.\u00a0Using default settings blindly.\u00a0Reluctance to learn a tool correctly.<\/p>\n

    These are the reasons for the aforementioned misleading charts (assuming that lying is not).<\/p>\n

    The common factor behind them is laziness<\/em> or casual attitude<\/em> aka sloth<\/strong>.<\/p>\n

    Lying or sloth? Take your pick.<\/p>\n

    At least lying is not one of the seven deadly sins.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In\u00a0Three Ways To Lie With Charts, we saw the following tactics: Slippery Slope Slide Floating Origin Fraud Dual Axis Deception The most common reason for people to lie with charts is that they are shilling some product, service or ideology and run into facts that derail their pitch, so they need to lie to continue … Read more<\/a><\/p>\n","protected":false},"author":4,"featured_media":5692,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,6,8,1],"tags":[],"class_list":["post-5698","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-b1-integrated-marketing","category-bfsi","category-it-marketing","category-mandatory-category"],"_links":{"self":[{"href":"https:\/\/gtm360.com\/blog\/wp-json\/wp\/v2\/posts\/5698","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gtm360.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gtm360.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gtm360.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/gtm360.com\/blog\/wp-json\/wp\/v2\/comments?post=5698"}],"version-history":[{"count":9,"href":"https:\/\/gtm360.com\/blog\/wp-json\/wp\/v2\/posts\/5698\/revisions"}],"predecessor-version":[{"id":9229,"href":"https:\/\/gtm360.com\/blog\/wp-json\/wp\/v2\/posts\/5698\/revisions\/9229"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gtm360.com\/blog\/wp-json\/wp\/v2\/media\/5692"}],"wp:attachment":[{"href":"https:\/\/gtm360.com\/blog\/wp-json\/wp\/v2\/media?parent=5698"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gtm360.com\/blog\/wp-json\/wp\/v2\/categories?post=5698"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gtm360.com\/blog\/wp-json\/wp\/v2\/tags?post=5698"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}