+ Reply to Thread
Results 1 to 4 of 4

Line Trend Chart show Percentage vs term

  1. #1
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,955

    Line Trend Chart show Percentage vs term

    Hi guys

    In attached sample file I am trying to create a trend chart...

    Pretty sure this is basic but I just can't get it to work...Works when values are numbers but not percentages...
    What am I missing...
    Attached Files Attached Files
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,244

    Re: Line Trend Chart show Percentage vs term

    Works, but the percentage format is just a format not number.
    In fact, under the percentage format 100% is "1", 85,5 % is "0,855" - "orders of magnitude" smaller numbers.
    Attached Files Attached Files
    Last edited by mjr veverka; 03-10-2018 at 10:25 AM.

  3. #3
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,955

    Re: Line Trend Chart show Percentage vs term

    Hi porucha

    So...What can i do to make it work? The percentage values are extracted via code

    Edit...Not to worry ...Changed the 1 2 3 4 to term 1 term 2 etc
    Last edited by Sintek; 03-10-2018 at 11:15 AM.

  4. #4
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,244

    Re: Line Trend Chart show Percentage vs term

    Sorry, but it seems I didn't quite understand the subject.
    Regarding the value to "Term", did you try to set the value of this column programmatically in the chart ?

    Please Login or Register  to view this content.

+ 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. Trend lines- Line chart
    By geraldccole in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-09-2016, 02:37 PM
  2. Bar Chart with trend or average line (XY)
    By overbomb in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-24-2014, 05:58 AM
  3. Bar chart with trend line
    By tani001 in forum Excel General
    Replies: 2
    Last Post: 05-11-2011, 07:04 AM
  4. Smooth Trend Line in Bar chart
    By earthworm in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-19-2010, 05:17 AM
  5. Chart Trend Line
    By mperata in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-31-2009, 03:30 PM
  6. Bar chart with a trend line
    By Russian in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-26-2006, 06:42 PM
  7. Idential trend line equations show different trends
    By Wired PSF in forum Excel General
    Replies: 2
    Last Post: 07-26-2006, 11:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1