+ Reply to Thread
Results 1 to 5 of 5

Chart to show Ranking Change

  1. #1
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    MS 365
    Posts
    532

    Chart to show Ranking Change

    Hi, i have a list of Brand in Column A, their Ranking for 2018 and 2017 in Column B and C.
    I duno if its possible to show have a chart that show the movement in the ranking so that its easilier for user to see the change.
    I have created a Sample in the attachment. Would appreciate if someone can tell me if its possible.

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Chart to show Ranking Change

    Something like the attached file? I just put this together manually.

    Hope this helps.

    Pete
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    MS 365
    Posts
    532

    Re: Chart to show Ranking Change

    thats a line with marker right?
    HOw do we put the axis on boths side? I mean the ranking 1,2,3,4,5 on both left and right side.
    And how we have the Brand name beside the Rank 2018 Dot?

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Chart to show Ranking Change

    Select one of the 2017 data points and select format data point > Series Option > Secondary Axis (which will then need formatting).
    Each individual 2018 data point will need a data label added and then formatted to show the series name.
    Note that I deleted the horizontal lines so that the series names could be more easily read.
    Note that I deleted the legend as that seems redundant if you are going to list the Brands in the chart.
    Let us know if you have any questions.
    (@Pete_UK -- off topic -- did you happen to see the 'Call in the Calvary' post I directed toward you -- your mailbox is not accepting new messages)
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Chart to show Ranking Change

    @JeteMc,

    I had noticed that you had tried to send me some PMs (I get notifications whenever this happens, as I keep my inbox full to avoid being inundated). I now see what they related to. I did see that thread when it was posted, so I'll respond to it shortly.

    Thanks,

    Pete

+ 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. Input score, Sort wins/ Losses and show ranking
    By tfurstnau in forum Excel General
    Replies: 2
    Last Post: 12-03-2016, 03:26 PM
  2. [SOLVED] Ranking Formula to show the top 25 from a list of 1000 - Any thoughts
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-23-2016, 04:27 PM
  3. Replies: 7
    Last Post: 03-29-2015, 10:15 AM
  4. [SOLVED] Change Chart Data Range to show YTD data
    By Harribone in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2015, 04:12 PM
  5. Replies: 1
    Last Post: 01-03-2012, 02:34 PM
  6. Replies: 2
    Last Post: 08-10-2010, 10:14 AM
  7. [SOLVED] change the data label of an chart to show qty
    By Trever B in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2005, 11: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1