+ Reply to Thread
Results 1 to 2 of 2

100% reference line chart

  1. #1
    Registered User
    Join Date
    08-18-2019
    Location
    Brussels
    MS-Off Ver
    2016
    Posts
    4

    100% reference line chart

    Hi guys, I need to make a chart but I am not finding useful info online.
    I need to make a chart where I compare different brands in percentage terms. My brand has to always be 100% along time, and the others have to display the percentage variation from my brand.
    Thank you in advance for the help

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: 100% reference line chart

    Hi
    I think the easiest way to do this would be to create a table of relative percentage based on your original data and graph that. The attached shows one possible way to do that.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Line chart too wide (52 weeks) How to make it the line chart automatically?
    By sovietchild in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 06-26-2016, 08:20 PM
  2. [SOLVED] Chart Lengend to show marker style on hidden line - Line chart
    By etaf in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-22-2013, 05:19 PM
  3. [SOLVED] Add reference line and notes to chart
    By akelic in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-05-2013, 04:19 AM
  4. Replies: 2
    Last Post: 11-14-2012, 08:59 AM
  5. [SOLVED] Display vertical line on stacked line chart already using primary and secondary axises
    By ben_hensel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-05-2012, 10:21 AM
  6. How to create a vertical reference line on a time series line chart
    By Bladebgii in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-23-2012, 10:17 AM
  7. Change Line Column Chart to Line Area chart
    By recchie in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-23-2005, 11:40 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1